Regression and hypothesis testing - Median Income for Familes
Not what you're looking for?
Fran's Mart are located throughout Erie, Pennsylvania, the owner would like to expand into other communities in northwestern Penn. and southwestern New York. As part of her presentation to the local bank, she would like to better understand the factors that make a particular outlet profitable. She must do all the work herself, so she will not be able to study all her outlets. She selects a random sample of 15 marts and records the average daily sales (Y), the floor space (area), the # of parking spaces, and the median income of families in that zip code region for each.
The sample information is attached.
a) Determine regression equation
b) What is value of R2(squared)? Comment on the value.
c) Conduct a global hypothesis test to determine if any of the independent variables are different from zero.
d) Conduct individual hypothesis tests to determine if any of the independent variables can be dropped
e) If variables are dropped, compute the regression equation and R2(squared)
Use Excel to solve parts or all of the problem if necessary.
Purchase this Solution
Solution Summary
The solution addresses Fran's Mart are located throughout Erie, Pennsylvania, the owner would like to expand into other communities in northwestern Penn. and southwestern New York. As part of her presentation to the local bank, she would like to better understand the factors that make a particular outlet profitable. She must do all the work herself, so she will not be able to study all her outlets. She selects a random sample of 15 marts and records the average daily sales (Y), the floor space (area), the # of parking spaces, and the median income of families in that zip code region for each.
The sample information is attached.
a) Determine regression equation
b) What is value of R2(squared)? Comment on the value.
c) Conduct a global hypothesis test to determine if any of the independent variables are different from zero.
d) Conduct individual hypothesis tests to determine if any of the independent variables can be dropped
e) If variables are dropped, compute the regression equation and R2(squared)
Solution Preview
Solution;
The regression equation form is y=B0+B1*x1+B2*x2+B3*X3
a)let y,x1,x2,x3 denote the variables sales,area,spaces,income.
Then the regression equation is y=1480.74+0.7315*x1+9.99149*x2-2.30826*x3.
b) R2=0.8354. this value can tell us that the model fits the data pretty good.
c)the global hypothesis test is MSR/MSE=3325.56/180.21=18.6 and p-value is 0.0001.so ...
Purchase this Solution
Free BrainMass Quizzes
Terms and Definitions for Statistics
This quiz covers basic terms and definitions of statistics.
Know Your Statistical Concepts
Each question is a choice-summary multiple choice question that presents you with a statistical concept and then 4 numbered statements. You must decide which (if any) of the numbered statements is/are true as they relate to the statistical concept.
Measures of Central Tendency
Tests knowledge of the three main measures of central tendency, including some simple calculation questions.
Measures of Central Tendency
This quiz evaluates the students understanding of the measures of central tendency seen in statistics. This quiz is specifically designed to incorporate the measures of central tendency as they relate to psychological research.