Sample Data for Supermarket Profits Food Sales (tens of thousands of dollars) Nonfood Sales (tens of thousands of dollar

[answerhappygod]

Sample Data For Supermarket Profits Food Sales Tens Of Thousands Of Dollars Nonfood Sales Tens Of Thousands Of Dollar 1 (106.03 KiB) Viewed 27 times

Sample Data for Supermarket Profits Food Sales (tens of thousands of dollars) Nonfood Sales (tens of thousands of dollars) Profit (thousands of dollars) Supermarket Number X1 X2 Y 1 35 20 305 129 2 28 15 3 189 83 17 9 4 175 101 269 76 93 5 16 6 77 27 44 7 8 425 195 282 203 35 7 22 47 31 92 9 10 23 USE EXCEL and note that this data set includes 2 variables: Food & Non-Food Sales... STORE SIZE IS NOT PART OF THIS PROBLEMS DATA SET!! 1. Run a multiple regression using the above data. (with profit as the dependent variable). 2. Compare the result of question (1) with another regression equation obtained without the food sales variable. 3. Which of the models do you prefer? Why? 4. Interpret your results for (1) and (2). Empirical Results: Discuss the descriptive statistics for each variable. Method: Explain what method you are using for your work. For example, you can start with telling the reader that the ordinary least squares method (OLS) was used to obtain estimated cocfficients... 1. Use the excel result to generate the equation. 2. Find the standard crror of each variable, 3. Find the t-stat of each variable. 4. Find the p-value of each variable.
EXAMPLE: Ý 1.24 1.71xi - 0.83x2 - 2.123 SH (6.79) (1.43) (0.22) (0.85) 10.181 11.201 T-stat P-value [3.78] 0.002 12.481 0.025 0.857 0.247 e) Results: Interpret the Coefficient of Determination (R!). F-test, t-test, p-value and etc. In addition, your result should use the hypothesis equation & hypothesis testing for a t-test about each slope coefficient and a F-test for the overall regression model.. EXAMPLE: For the t-test, it is written like this: HB = 0 H$: B40 Note: You have to decide whether to use one-tail or two-tail test Declare your altemative hypothesis in each case very well T-test: H :B. = B2 = B3 = 0 Hu: B. 7 B2 B3 0, or all three are 70 (Note that: remember to mention what a is used in your hypothesis testing). Discussion: Describe what your findings mean and how they relate to projecting market profits.