You are working for a large firm on the marketing and price communications team

profileJesus Pawned
Project_Data_S19.xlsx

Sheet1

Region Product Type Item Projected Sales 2022 (in millions) Projected Sales 2027 (in millions) Projected Sales 2032 (in millions) legacy 2022 2027 2032 legacy 2022 2027 2032 legacy 2022 2027 2032
Americas Legacy A 9 0.8 6.4 mean A 7.1706896552 7.0275862069 3.2413793103 standard diviation A 5.2660784244 3.019805565 2.6409749982 value of coefficient A 73.4389% 42.9707% 81.4769%
Americas Legacy A 8.5 7.8 3.2 mean B 7.1103448276 7.2568965517 2.7431034483 standard diviation B 4.6974307892 2.4747930673 2.5977798935 value of coefficient B 66.0647% 34.1026% 94.7022%
Americas Legacy A 13 11.2 8.6 mean C 7.15 6.9155172414 2.7034482759 standard diviation C 4.1213287757 3.4183099202 3.8441555328 value of coefficient C 57.6410% 49.4296% 142.1945%
Americas Legacy A 8 7.5 8.1 mean D 6.7280701754 7.3666666667 2.8245614035 standard diviation D 5.158445031 3.7589100497 3.5461891367 value of coefficient D 76.6705% 51.0259% 125.5483%
Americas Legacy A 10.2 14.1 8.3
Americas Legacy A 15.5 12.6 8.9 New 2022 2027 2032 new 2022 2027 2032 New 2022 2027 2032
Americas Legacy A 10.8 11.4 7.6 mean A 16.7381818182 12.0945454545 8.2963636364 standard diviation A 2.8770156161 2.2401569209 2.2852962881 value of coefficient A 17.1883% 18.5220% 27.5458%
Americas Legacy A 7.5 12.8 7.2 mean B 17.1203703704 12.1763636364 8.4036363636 standard diviation B 3.3272874464 2.5286479799 2.1808903751 value of coefficient B 19.4347% 20.7669% 25.9517%
Americas Legacy A 4.4 10.3 6.6 mean C 18.3092592593 12.0574074074 8.1222222222 standard diviation C 2.6502594048 2.5309854783 2.1408574077 value of coefficient C 14.4750% 20.9911% 26.3580%
Americas Legacy A 15.4 6.6 5 mean D 17.6381818182 12.4945454545 8.0509090909 standard diviation D 3.3571643076 2.0957998722 2.1982208907 value of coefficient D 19.0335% 16.7737% 27.3040%
Americas Legacy A 11.2 9.3 4.5
Americas Legacy A 13.7 9.6 5.5
Americas Legacy A 9.6 11.7 5.6
Americas Legacy A 3.3 7.8 5.3
Americas Legacy A 14 6 4.3
Americas Legacy A 10.3 9.7 6.5
Americas Legacy A -3.9 9.4 5.4
Americas Legacy A 7.7 9.7 5.1
Americas Legacy A 5.7 6 1.7
Americas Legacy A -2 7.9 3.9
Americas Legacy A -3.3 3 1.1
Americas Legacy A 4.1 7.4 2
Americas Legacy A 13.4 7.1 2.8
Americas Legacy A 10.3 7.7 2.3
Americas Legacy A 1.6 5.1 1.1
Americas Legacy A 16.4 7.7 4.1
Americas Legacy A 7.4 6.2 3.1
Americas Legacy A 5.5 5.3 1.7
Americas Legacy A 6.3 7 3
Americas Legacy A 11.4 9.7 4.8
Americas Legacy A 10.8 6.8 3.1
Americas Legacy A 11.4 6.7 3.3
Americas Legacy A -3.5 7.2 4.6
Americas Legacy A 9 7.6 2.4
Americas Legacy A 0 7.3 2.7
Americas Legacy A 5.3 6.1 2.1
Americas Legacy A 10.8 8.2 3.5
Americas Legacy A 16.9 8.7 4
Americas Legacy A 8.4 5.9 2.7
Americas Legacy A -0.3 2.5 2.9
Americas Legacy A 5.4 5.6 1.1
Americas Legacy A -1 6.9 2
Americas Legacy A 11.3 10.1 2.4
Americas Legacy A 6.1 6.5 2.9
Americas Legacy A 3.9 6.8 1.6
Americas Legacy A -1.8 2.1 0.5
Americas Legacy A 1.8 3.9 -0.2
Americas Legacy A 7.8 5 0.8
Americas Legacy A 14.1 4 0.7
Americas Legacy A 7.5 7 1.5
Americas Legacy A 6.2 4.6 0.5
Americas Legacy A 4.6 6.1 0.7
Americas Legacy A 8.9 6.1 -0.4
Americas Legacy A 5.2 5.2 1.3
Americas Legacy A -1.1 -4 -5.4
Americas Legacy A 5.9 4.1 0.1
Americas Legacy A 6.5 5.8 1
Americas Legacy A 10.8 6.4 1.9
Americas New A 18.8 14.1 9.4
Americas New A 21.2 18 12.2
Americas New A 18.5 12.5 9.9
Americas New A 16.6 12.8 10.2
Americas New A 17.1 15.3 9.9
Americas New A 13.4 13.6 14
Americas New A 16.5 13.2 13.1
Americas New A 20.6 15.8 10.5
Americas New A 16.6 14.7 13.9
Americas New A 16.6 12.8 9.9
Americas New A 18.2 12.6 11.2
Americas New A 16.6 14.4 9.3
Americas New A 18.7 13 10.3
Americas New A 20.6 11.1 7.7
Americas New A 15.6 13.2 9.2
Americas New A 15.6 10.7 7.3
Americas New A 17.7 13.3 9
Americas New A 19.1 13 8.7
Americas New A 20 12.8 8.8
Americas New A 17.4 12.8 9
Americas New A 20.5 14.9 8.8
Americas New A 19.5 11.7 7.9
Americas New A 19 12.4 8
Americas New A 18.4 14.2 10.3
Americas New A 19.6 12.2 8.8
Americas New A 18.9 15.4 9.8
Americas New A 19.7 12.3 8.5
Americas New A 18.5 11.9 7.8
Americas New A 16 11.7 7.6
Americas New A 18.1 12.4 6.6
Americas New A 19.5 10.7 6.6
Americas New A 15.6 11.6 6.5
Americas New A 16 11.5 7.4
Americas New A 8.2 12.1 8.8
Americas New A 15.5 11.1 7.4
Americas New A 14.4 11.5 8.1
Americas New A 15.2 12.3 9
Americas New A 20.8 13 8.3
Americas New A 16.4 10.4 6.6
Americas New A 18.1 13.9 10.2
Americas New A 16.1 12.4 8.4
Americas New A 14.1 11.3 8.8
Americas New A 17.8 13.5 7.9
Americas New A 13.2 9.8 6.4
Americas New A 17.9 6.5 4.2
Americas New A 16.4 9.9 7.1
Americas New A 14.6 9.1 6.1
Americas New A 20.2 12.3 6.9
Americas New A 14.2 6.7 4
Americas New A 9.9 10.1 6.1
Americas New A 12.9 12.9 6.3
Americas New A 11.6 7.7 5.6
Americas New A 11.9 10.9 3.6
Americas New A 14.7 7.3 3.7
Americas New A 11.8 7.9 4.7
Americas Legacy B 18.6 11.2 2.1
Americas Legacy B 1.4 9.7 3.2
Americas Legacy B 9.4 8.8 2.5
Americas Legacy B 11.6 10.3 6.4
Americas Legacy B 7.1 10.2 8
Americas Legacy B 8.6 7.8 10
Americas Legacy B 6.9 8.4 6.7
Americas Legacy B 9.4 11.3 6.3
Americas Legacy B 8 10.1 4.3
Americas Legacy B 12.4 8 5
Americas Legacy B 16.3 8.5 5
Americas Legacy B 12.4 8.2 4.6
Americas Legacy B 5.7 10.8 4.1
Americas Legacy B 8.1 10.8 5.7
Americas Legacy B 14.6 8.2 5.8
Americas Legacy B 3.2 9.4 5.2
Americas Legacy B 13.1 8.4 4.7
Americas Legacy B 6.5 9.2 4.9
Americas Legacy B 6.6 8.1 3.2
Americas Legacy B 14 9.1 2.5
Americas Legacy B -1.6 3.4 1.7
Americas Legacy B -5.5 3.2 3.1
Americas Legacy B 10.5 6.7 3.5
Americas Legacy B 9.7 6.7 3.6
Americas Legacy B 5.9 8.3 3.4
Americas Legacy B 9 6.1 1.2
Americas Legacy B 7.9 11.5 1.5
Americas Legacy B 4.4 6.8 2.5
Americas Legacy B 8.2 8.4 2.2
Americas Legacy B 2.9 4.3 1.4
Americas Legacy B 10.6 6.4 2.8
Americas Legacy B 7.8 6.3 1.2
Americas Legacy B 5.2 5.1 3.1
Americas Legacy B 14.4 9.3 2.9
Americas Legacy B 4.1 9.1 3.5
Americas Legacy B 7.7 6.8 2.1
Americas Legacy B 2.6 5.7 3.3
Americas Legacy B 10.1 8.1 1.9
Americas Legacy B 8.4 5.5 2.1
Americas Legacy B 7.2 7.5 3.7
Americas Legacy B -6.5 6.8 3.7
Americas Legacy B -0.5 7.1 0.9
Americas Legacy B 5.8 9.1 2.8
Americas Legacy B 9 7.1 3.4
Americas Legacy B 5 6.7 3.7
Americas Legacy B 7.5 5.4 0.9
Americas Legacy B 6.3 4.7 1
Americas Legacy B 4 6.7 0.7
Americas Legacy B 4.6 5.1 -0.8
Americas Legacy B 7.3 5.9 1
Americas Legacy B 8.9 3.7 -0.9
Americas Legacy B 6.1 3.9 -1.1
Americas Legacy B 5.3 5.6 -6.1
Americas Legacy B 9.6 6 1.8
Americas Legacy B 9.3 6.9 0.5
Americas Legacy B 4.8 5.5 -0.1
Americas Legacy B 2.6 5.8 0.2
Americas Legacy B -0.1 -2.8 -3.4
Americas New B 21 14.7 10.3
Americas New B 18.7 15.7 12
Americas New B 19 15.4 11.3
Americas New B 15.1 17.4 11.1
Americas New B 16.7 14.4 10.8
Americas New B 20 15.8 11.5
Americas New B 20.4 14.4 9.6
Americas New B 21 14.8 11.8
Americas New B 19.7 17 13.2
Americas New B 19.3 12.9 10.8
Americas New B 18.4 15.4 10.6
Americas New B 15.1 13 10.5
Americas New B 18.5 13.5 9.2
Americas New B 16.2 10.5 7.9
Americas New B 19.7 12.8 8.7
Americas New B 14.6 10.8 8.1
Americas New B 20.4 13.3 7.7
Americas New B 15.1 12.7 9.4
Americas New B 19.8 15 9.8
Americas New B 14.8 11 8.5
Americas New B 16.6 10 8.6
Americas New B 12 12.3 8.3
Americas New B 19.8 13.3 7.5
Americas New B 17.8 15.2 9.9
Americas New B 20.1 11 8.1
Americas New B 15.9 10.8 8
Americas New B 11.7 12.9 7.8
Americas New B 20.4 13 7.7
Americas New B 17.6 11 7.8
Americas New B 18.4 11.4 7.5
Americas New B 20.7 13.8 9.7
Americas New B 19.3 11 8.7
Americas New B 15.8 12.4 10.3
Americas New B 13.7 6.8 8.2
Americas New B 19.3 12.2 9.3
Americas New B 17.7 10.6 7.5
Americas New B 8.3 6.9 6.9
Americas New B 22.9 14.6 9.1
Americas New B 15.3 10.7 7.7
Americas New B 14.3 12.2 9
Americas New B 16 13.2 9.6
Americas New B 19.3 12.4 8.6
Americas New B 18.7 11.7 7.2
Americas New B 13.6 9.6 5.9
Americas New B 21 12.3 6.6
Americas New B 21 12.6 7
Americas New B 16.9 9.3 5.9
Americas New B 14.1 10.1 6.9
Americas New B 16.6 10.2 5.7
Americas New B 23.2 14.6 6.6
Americas New B 17.6 9.5 6.7
Americas New B 9.6 9 5.7
Americas New B 10.3 8.1 4.9
Americas New B 12.1 7.7 4
Americas New B 14.4 6.8 0.5
Americas Legacy C 0.6 3.5 11.7
Americas Legacy C 8.4 9.5 2.5
Americas Legacy C 13.1 10.4 6.3
Americas Legacy C 10.9 12.4 8
Americas Legacy C 9.1 13.2 7.9
Americas Legacy C 6.6 9.2 7.4
Americas Legacy C 14 10.2 6.2
Americas Legacy C 11.2 10.2 6.5
Americas Legacy C 5.8 6.2 6.7
Americas Legacy C 11.7 9.3 5.1
Americas Legacy C 13.2 8.9 4.7
Americas Legacy C 12.4 9.6 4.6
Americas Legacy C 13 8.9 4.5
Americas Legacy C 7.8 10.7 5.8
Americas Legacy C 9.2 9.7 5.6
Americas Legacy C 9.2 9.3 4.1
Americas Legacy C 2.7 7.7 5.3
Americas Legacy C 12.6 10.1 4.2
Americas Legacy C 8.1 6 3.7
Americas Legacy C 7.3 8.2 3
Americas Legacy C 3.3 3.2 1.5
Americas Legacy C 3 5.5 1
Americas Legacy C 11.4 7.3 3.8
Americas Legacy C 4.6 7.9 3.4
Americas Legacy C 3.5 5.7 2.5
Americas Legacy C 8.3 8 2.4
Americas Legacy C 9.1 8.8 4.2
Americas Legacy C 13.8 7.9 3
Americas Legacy C 7.8 7.8 3.6
Americas Legacy C 8.9 6.7 2.5
Americas Legacy C 10.1 6.1 2.7
Americas Legacy C 1.4 4 2.8
Americas Legacy C 4.7 8.9 2.5
Americas Legacy C 9.4 8.7 2
Americas Legacy C 7.1 5.9 2.2
Americas Legacy C 7.5 6.2 2.7
Americas Legacy C 6.6 5.5 3.8
Americas Legacy C 6.3 5.7 1.2
Americas Legacy C 9.5 10.6 3.5
Americas Legacy C 6.8 4.3 2.6
Americas Legacy C 9.5 7.9 2.4
Americas Legacy C 6.4 5.7 1.7
Americas Legacy C 3.6 8.6 3
Americas Legacy C 10.2 6.1 3.1
Americas Legacy C 7.8 5.6 0.3
Americas Legacy C -2 4.1 0.6
Americas Legacy C 4.7 3.1 -0.7
Americas Legacy C 5.9 5.8 1.4
Americas Legacy C 3.3 4.8 0
Americas Legacy C 7.9 5.5 -0.2
Americas Legacy C 7.5 6.2 0.6
Americas Legacy C 1.1 3.1 0.1
Americas Legacy C -8 -11.7 -17.6
Americas Legacy C 5.3 5.4 -5.9
Americas Legacy C 8.6 4.3 -0.9
Americas Legacy C 6.9 6 0.8
Americas Legacy C 1.8 6.6 -0.4
Americas Legacy C 4.2 6.1 0.8
Americas New C 21.7 13.5 10.5
Americas New C 19.7 12.4 9.4
Americas New C 15.8 16.8 13.2
Americas New C 18.5 15.6 12.8
Americas New C 19.2 14.9 10.6
Americas New C 22 14.9 10.7
Americas New C 19.9 13.3 11.1
Americas New C 18.4 14.2 10.9
Americas New C 18.1 13.7 9.8
Americas New C 19.1 12.6 9.3
Americas New C 14.9 14.9 12.1
Americas New C 22.1 14.7 9.5
Americas New C 17.7 15.2 11.5
Americas New C 20.8 11.1 7.7
Americas New C 21.2 13.5 7.7
Americas New C 15.3 6.8 6.5
Americas New C 20.9 13.3 8.2
Americas New C 23.4 11.8 7.6
Americas New C 20 13.6 8.9
Americas New C 18.8 15.3 9.7
Americas New C 19.8 12.1 8.7
Americas New C 19.8 11.2 7.4
Americas New C 16 10.9 7.7
Americas New C 16.1 12 7.3
Americas New C 21.8 7.6 6.9
Americas New C 20.6 13.8 8.9
Americas New C 19.2 17 9.9
Americas New C 18 11.3 6
Americas New C 16.8 11 6.8
Americas New C 16.3 6.8 6.9
Americas New C 16.7 13.8 7.9
Americas New C 18.3 9.3 6.9
Americas New C 21.9 10.1 6.8
Americas New C 22.3 15.8 9
Americas New C 15.9 12.3 9.6
Americas New C 18.9 13.7 7.5
Americas New C 16 12.5 7.5
Americas New C 13.1 7.6 6.5
Americas New C 15.4 11.7 9.2
Americas New C 18.1 13.9 10.2
Americas New C 19.6 11.4 6.6
Americas New C 16.6 11.5 7.8
Americas New C 18.9 11.3 8.4
Americas New C 15.3 8.3 6.6
Americas New C 16.6 10.2 6.2
Americas New C 20.6 11.9 5.5
Americas New C 17.9 11.3 5.7
Americas New C 11.2 8.2 5.6
Americas New C 13.7 9.4 5.5
Americas New C 18.6 11.1 5.2
Americas New C 17.7 10.1 5.7
Americas New C 17.1 12.6 7.1
Americas New C 14 7.3 3.7
Americas New C 22.4 10 3.7
Americas Legacy D 4.6 4.6 1.1
Americas Legacy D 6.9 9.3 0.9
Americas Legacy D 14.7 12.1 8.1
Americas Legacy D 10.3 10.7 8
Americas Legacy D 12.3 15 7.7
Americas Legacy D 12.3 11 6.2
Americas Legacy D 8.6 12 7.3
Americas Legacy D 12.3 13 8.4
Americas Legacy D 6.5 9.4 5.4
Americas Legacy D 7.2 6.3 5.4
Americas Legacy D 14.2 12.3 7.1
Americas Legacy D 12.4 10.2 5.3
Americas Legacy D 13.2 9.6 4
Americas Legacy D 8.7 8.7 3.8
Americas Legacy D 9.7 7.9 3.8
Americas Legacy D 9.7 8.3 4.5
Americas Legacy D 6.7 9.5 8.5
Americas Legacy D 6.6 9.8 5.3
Americas Legacy D 4.2 6.5 1.5
Americas Legacy D 7.9 7.5 2.7
Americas Legacy D 8.4 6.1 1.7
Americas Legacy D 3.7 6.6 3.6
Americas Legacy D 15.4 9.7 4
Americas Legacy D 2.6 6.5 1.2
Americas Legacy D 13.1 8.2 3.4
Americas Legacy D 7.2 6.6 1.3
Americas Legacy D 4.9 6.8 4.1
Americas Legacy D 8.4 5.3 2.4
Americas Legacy D 2.3 8.5 2.9
Americas Legacy D 9.2 6.9 2.8
Americas Legacy D 1.5 8 2.4
Americas Legacy D 4.3 3.2 2.7
Americas Legacy D 6.5 9.9 2.5
Americas Legacy D 7.5 9.7 2.4
Americas Legacy D 8 5.4 1.4
Americas Legacy D 10.3 8.2 2.6
Americas Legacy D 10.9 9.3 3.6
Americas Legacy D 12 7.7 3.9
Americas Legacy D 14.1 8 3.5
Americas Legacy D -5.1 3.6 3.1
Americas Legacy D 5.3 8.5 3
Americas Legacy D 4 8.8 2
Americas Legacy D 4.6 6 1.5
Americas Legacy D 4.7 9.6 4.6
Americas Legacy D -9 7 0.3
Americas Legacy D 2.7 5.1 -0.1
Americas Legacy D 8.9 6.1 1.3
Americas Legacy D -2.4 0.3 -1
Americas Legacy D 5 4.7 -0.1
Americas Legacy D 5.9 5.8 1.4
Americas Legacy D 4.5 8.7 1.5
Americas Legacy D 2.6 2.3 -1.1
Americas Legacy D 9.6 6 1.6
Americas Legacy D -8 -11.9 -16.6
Americas Legacy D 8.6 5.5 0.7
Americas Legacy D 0.1 5.8 1.2
Americas Legacy D 2.2 3.7 0.3
Americas New D 12.3 16.1 13.9
Americas New D 22.1 15.7 12.9
Americas New D 19.8 12.6 9.7
Americas New D 15.7 11.2 9.4
Americas New D 14.9 14.7 11.3
Americas New D 14.2 14 10
Americas New D 22 14.9 10.9
Americas New D 24.7 17.4 11.2
Americas New D 13.2 16.8 10.2
Americas New D 19.4 14.4 9.2
Americas New D 19.8 13.7 9.8
Americas New D 19 14.2 9.5
Americas New D 18.2 14.4 10.1
Americas New D 16.4 12.3 7.3
Americas New D 11.8 9 8.9
Americas New D 21.4 10.9 8.1
Americas New D 20.1 13.7 7.3
Americas New D 19.7 12.7 7.1
Americas New D 23.6 13.8 9.3
Americas New D 20.1 10.9 7.2
Americas New D 19 14.9 9.5
Americas New D 13.7 9.3 8
Americas New D 18.3 12.7 7.3
Americas New D 17.4 9.8 10
Americas New D 11.8 8.9 6.4
Americas New D 19.4 12.8 7.7
Americas New D 16.2 11.3 8.1
Americas New D 20.6 12.4 7.3
Americas New D 10 10.7 7.5
Americas New D 20.2 14.1 7.6
Americas New D 15.8 12.3 7.1
Americas New D 17.1 13.1 8.6
Americas New D 13.6 13.1 9.7
Americas New D 15.3 11.4 7.1
Americas New D 23.3 14.9 9.2
Americas New D 20.3 15.6 8.6
Americas New D 18.2 12.3 7.3
Americas New D 22.1 13.1 8.5
Americas New D 17.3 10.6 7.2
Americas New D 17.3 12 9.4
Americas New D 19 12.1 7.5
Americas New D 20.6 12.7 8.6
Americas New D 18 10.3 7.6
Americas New D 12.2 10.8 6.4
Americas New D 16.9 10.7 5.6
Americas New D 14.7 7.9 4.3
Americas New D 15.8 10.6 6.3
Americas New D 18.3 11.4 6.6
Americas New D 19.8 13.5 7.1
Americas New D 15.8 10.6 6.8
Americas New D 20.8 13.4 7.1
Americas New D 14.4 9.2 4.9
Americas New D 15.5 11.7 2.1
Americas New D 20.2 13.3 2.2
Americas New D 12.8 10.3 4.3

Sheet2

Sheet3