The management team initially wants to use Excel Linear Regression Analysis to take the data

 

for the 20 stores that is in Table 1 to develop a best fit linear equation of the form:

 

Y = a + b X1

 

where Y is the profit and X1 is the sales level. They are interested in seeing if there is a

 

relationship between the profit and the sales levels of their 20 stores. Table 1 is a summary of

 

Casey Hardware stores’ performance, profits versus sales.

 

© 2021 Strayer University. All Rights Reserved. This document contains Strayer University Confidential and Proprietary information and may

 

not be copied, further distributed, or otherwise disclosed in whole or in part, without the expressed written permission of Strayer University.

 

Page 2 of 4

 

Table 1. Summary of Casey Hardware Stores’ Performance Profits Versus Sales

 

Store # Profits ($000s) Sales ($000s)

 

1 42.13 748.82

 

2 6.32 140.78

 

3 38.47 702.11

 

4 -0.32 41.54

 

5 3.65 96.85

 

6 7.77 166.93

 

7 4.31 109.05

 

8 4.53 263.92

 

9 -2.69 50.84

 

10 3.22 90.08

 

11 9.03 190.59

 

12 -2.59 91.75

 

13 6.39 141.57

 

14 24.39 377.04

 

15 13.93 198.69

 

16 2.13 62.78

 

17 17.48 265.28

 

18 7.21 91.8

 

19 15.62 231.6

 

20 33.61 548.31

 

© 2021 Strayer University. All Rights Reserved. This document contains Strayer University Confidential and Proprietary information and may

 

not be copied, further distributed, or otherwise disclosed in whole or in part, without the expressed written permission of Strayer University.