A B C D E 1 - Part 3 Regression Analysis 2 3 Gina's Boutiques has...

Transcribed Image Text:

A B C D E 1 - Part 3 Regression Analysis 2 3 Gina's Boutiques has 12 locations in the Mid-Atlantic 4 region. Revenues and Costs for each store are 5 given in the table below. Use the data to perform a 6 simple regression analysis (Menu >Tools>Choose Regression) 7 within Excel. (The Text, Chapter 5 Appendix A has further 8 details). 9 in $1000's 10 Store Revenues Costs 11 1101 $ 4,103.6 $ 4,214.0 12 1102 $ 2,218.6 $ 2,895.0 13 1103 $ 6,250.4 $ 5,179.0 14 1104 $ 3,986.8 $ 4,004.0 15 1105 $ 2,921.2 $ 3,676.0 16 1106 $ 4,180.4 $ 3,201.0 17 1107 $ 6,885.6 $ 5,034.0 18 1108 $ 1,788.6 $ 2,382.0 19 1109 $ 5,406.4 $ 4,692.0 20 1110 $ 3,236.4 $ 4,352.0 21 1111 $ 3,876.4 $ 4,181.0 22 1112 $ 4,018.2 $ 3,327.0 23 F A B C D E 1 - Part 3 Regression Analysis 2 3 Gina's Boutiques has 12 locations in the Mid-Atlantic 4 region. Revenues and Costs for each store are 5 given in the table below. Use the data to perform a 6 simple regression analysis (Menu >Tools>Choose Regression) 7 within Excel. (The Text, Chapter 5 Appendix A has further 8 details). 9 in $1000's 10 Store Revenues Costs 11 1101 $ 4,103.6 $ 4,214.0 12 1102 $ 2,218.6 $ 2,895.0 13 1103 $ 6,250.4 $ 5,179.0 14 1104 $ 3,986.8 $ 4,004.0 15 1105 $ 2,921.2 $ 3,676.0 16 1106 $ 4,180.4 $ 3,201.0 17 1107 $ 6,885.6 $ 5,034.0 18 1108 $ 1,788.6 $ 2,382.0 19 1109 $ 5,406.4 $ 4,692.0 20 1110 $ 3,236.4 $ 4,352.0 21 1111 $ 3,876.4 $ 4,181.0 22 1112 $ 4,018.2 $ 3,327.0 23 F