cors.) (6 points) Question 10 Using the data provided in Exhibit 4, perform a regression analysis...

Transcribed Image Text:

cors.) (6 points) Question 10 Using the data provided in Exhibit 4, perform a regression analysis on the data, and include residuals in your output. Based on these results, which variables are most important in determining sales? You may keep all data within Excel. (See the Regression Tips document in this week's folder.) (8 points) Question 11 What do the residuals mean? What does a negative residual mean in terms of potential errors and what does a positive residual mean in term of potential errors? Which is more of a concern to auditors? (3 points) Exhibit 4 On the Go Stores Regression Data (1-4,000 sq.ft.; Merchandise Full-Time (1-yes, 0-no) (1-yes, 0-no) Store Inventory Employees New Store Sells Gas 1 48,725 11 1 0 0-2,500 sq.ft.) Size Sales 0 781,793 2345 CO 44,171 11.31 0 0 0 1,146,438 45,714 12.46 0 0 0 1,195,004 37,218 11.86 1 0 1 951,784 45,826 10.06 0 1 1 1,981,409 6 53,862 11.1 0 1 1 2,300,671 7 49,883 10.71 0 1 1 1,956,481 8 47,016 7.5 0 1 1 1,799,713 9 59,726 14 0 0 1 1,820,641 10 35,882 11.2 1 0 0 774,954 11 37,664 11.6 0 0 0 1,159,004 12 34,662 12.7 0 0 0 1,139,475 13 44,782 11.86 1 0 1 948,522 1 14 38,774 12.2 0 1 1 1,984,777 2 15 3 16 56 55,423 11.1 0 1 1 2,293,847 52,884 10.4 0 1 1 1,984,722 4 17 46,834 8.84 0 1 1 1,798,336 5 18 53,772 12.1 0 1 1 2,484,503 26 19 43,982 9.7 0 1 1 1,837,400 27 20 44,893 7.2 0 1 28 1 1,609,385 21 37,665 10.5 0 1 1 1,874,229 29 22 33,826 10.5 1 0 0 30 698,333 23 44,857 10.9 0 0 31 0 1,198,229 32 33 34 35 36 37 38 39 40 A4 cors.) (6 points) Question 10 Using the data provided in Exhibit 4, perform a regression analysis on the data, and include residuals in your output. Based on these results, which variables are most important in determining sales? You may keep all data within Excel. (See the Regression Tips document in this week's folder.) (8 points) Question 11 What do the residuals mean? What does a negative residual mean in terms of potential errors and what does a positive residual mean in term of potential errors? Which is more of a concern to auditors? (3 points) Exhibit 4 On the Go Stores Regression Data (1-4,000 sq.ft.; Merchandise Full-Time (1-yes, 0-no) (1-yes, 0-no) Store Inventory Employees New Store Sells Gas 1 48,725 11 1 0 0-2,500 sq.ft.) Size Sales 0 781,793 2345 CO 44,171 11.31 0 0 0 1,146,438 45,714 12.46 0 0 0 1,195,004 37,218 11.86 1 0 1 951,784 45,826 10.06 0 1 1 1,981,409 6 53,862 11.1 0 1 1 2,300,671 7 49,883 10.71 0 1 1 1,956,481 8 47,016 7.5 0 1 1 1,799,713 9 59,726 14 0 0 1 1,820,641 10 35,882 11.2 1 0 0 774,954 11 37,664 11.6 0 0 0 1,159,004 12 34,662 12.7 0 0 0 1,139,475 13 44,782 11.86 1 0 1 948,522 1 14 38,774 12.2 0 1 1 1,984,777 2 15 3 16 56 55,423 11.1 0 1 1 2,293,847 52,884 10.4 0 1 1 1,984,722 4 17 46,834 8.84 0 1 1 1,798,336 5 18 53,772 12.1 0 1 1 2,484,503 26 19 43,982 9.7 0 1 1 1,837,400 27 20 44,893 7.2 0 1 28 1 1,609,385 21 37,665 10.5 0 1 1 1,874,229 29 22 33,826 10.5 1 0 0 30 698,333 23 44,857 10.9 0 0 31 0 1,198,229 32 33 34 35 36 37 38 39 40 A4