Question

Store Size (thousands of square feet) Sales (millions$) 3.7 9.18 2.0 4.58 5.0 8.22 0.7 1.45 2.6 6.51 2.9 2.82 5.2 10.45 5.9 9.94 3.0 4.43 2.4 4.75 2.4 7.30 0.5 3.33 5.0 6.76 0.4 0.55 4.2 7.56 3.1 2.23 2.6 4.49 5.2 9.90 3.3 8.93 3.2 7.60 4.9 3.71 5.5 5.47 2.9 8.22 2.2 7.17 2.3 4.35 Macy’s is a chain of woman’s clothing stores with locations in Hawaii and on the mainland U.S. Due to recent success, top management is planning to expand by locating stores in Canada. The director of planning has been asked to study whether store size impacts yearly sales. As part of the study, the director selects a sample of 25 stores and determines the size of the store in square feet and the sales for the last year. The sample data can be found in the EXCEL file. Run a correlation and regression analysis. 1. What is the dependent variable (Y)? A. Sales and Store Size B. Sales C. Store size 2. What is the value of the coefficient of correlation? A. -0.43 B. 0.66 C. 0.43 D. -0.66 3. What can you say about the correlation? A. There is a fairly strong negative correlation B. There is a fairly strong positive correlation C. There is no correlation D. There is a very weak positive correlation 4. Does store size impact Sales? A. No B. Yes C. It cannot be determined 5. What is the p-value for the regression test? A. 0.00 B. 0.04 C. 0.43 D. 0.10 6. What is the coefficient of determination? A. 0.17 B. 0.43 C. 0.66 D. 0.35 7. What is the regression equation? A. It cannot be determined B. Y = 1.18 + 2.17X C. Y = 2.15 + 4.49X D. Y = 2.17 + 1.18X 8. How much variability in the dependent variable is due to the independent variable? A. 52% B. 49% C. 66% D. 43% 9. What would you predict the sales to be if the store had 5,000 square feet? A. $8.1 million B. $6.5 million C. $5.4 million D. $9.6 million 10. What would you predict the sales to be if the store had 2,000 square feet? A. $4.5 million B. $2.4 million C. $6.5 million D. $3.6 million

          Store Size
(thousands of square feet)
Sales 
(millions$)
3.7
9.18
2.0
4.58
5.0
8.22
0.7
1.45
2.6
6.51
2.9
2.82
5.2
10.45
5.9
9.94
3.0
4.43
2.4
4.75
2.4
7.30
0.5
3.33
5.0
6.76
0.4
0.55
4.2
7.56
3.1
2.23
2.6
4.49
5.2
9.90
3.3
8.93
3.2
7.60
4.9
3.71
5.5
5.47
2.9
8.22
2.2
7.17
2.3
4.35
 
Macy’s is a chain of woman’s clothing stores with locations in
Hawaii and on the mainland U.S.  Due to recent success,
top management is planning to expand by locating stores in
Canada.  The director of planning has been asked to study
whether store size impacts yearly sales. As part of the study,
the director selects a sample of 25 stores and determines the size
of the store in square feet and the sales for the last
year.  The sample data can be found in the EXCEL
file.  Run a correlation and regression analysis.
 
1. What is the dependent variable (Y)?
              A.          Sales
and Store Size
              B.          Sales
              C.          Store
size
 
2. What is the value of the coefficient of correlation?
              A.          -0.43
              B.          0.66
              C.          0.43
              D.          -0.66
 
3. What can you say about the correlation?
 
              A.          There
is a fairly strong negative correlation
              B.          There
is a fairly strong positive correlation
              C.          There
is no correlation
              D.          There
is a very weak positive correlation
 
4. Does store size impact Sales?
 
              A.          No
              B.          Yes
              C.          It
cannot be determined
 
5. What is the p-value for the regression test?
 
              A.          0.00
              B.          0.04
              C.          0.43
              D.          0.10
 
6. What is the coefficient of determination?
 
              A.          0.17
              B.          0.43
              C.          0.66
              D.          0.35
 
7. What is the regression equation?
 
              A.          It
cannot be determined
              B.          Y
= 1.18 + 2.17X
              C.          Y
= 2.15 + 4.49X
              D.          Y
= 2.17 + 1.18X
 
8. How much variability in the dependent variable is due to the
independent variable?
 
              A.          52%
              B.          49%
              C.          66%
              D.          43%
 
9. What would you predict the sales to be if the store had 5,000
square feet?
 
              A.          $8.1
million
              B.          $6.5
million
              C.          $5.4
million
              D.          $9.6
million
 
10. What would you predict the sales to be if the store had
2,000 square feet?
 
              A.          $4.5
million
              B.          $2.4
million
              C.          $6.5
million
              D.          $3.6
million

Added by Jon C.

Question

Please give Ace some feedback