c. What does the standard error of estimate tell you about the model? ANSWER: d. Assess the independent variables significance at 5% level (develop hypothesis if necessary in the analysis)? ANSWER:
Correlation
Correlation defines a relationship between two independent variables. It tells the degree to which variables move in relation to each other. When two sets of data are related to each other, there is a correlation between them.
Linear Correlation
A correlation is used to determine the relationships between numerical and categorical variables. In other words, it is an indicator of how things are connected to one another. The correlation analysis is the study of how variables are related.
Regression Analysis
Regression analysis is a statistical method in which it estimates the relationship between a dependent variable and one or more independent variable. In simple terms dependent variable is called as outcome variable and independent variable is called as predictors. Regression analysis is one of the methods to find the trends in data. The independent variable used in Regression analysis is named Predictor variable. It offers data of an associated dependent variable regarding a particular outcome.
Regression model
I need part c and d only
![You are required to;
a. Complete the missing entries from A to L in this output
ANSWER:
b. Derive the regression model
ANSWER:
c. What does the standard error of estimate tell you about the model?
ANSWER:
d. Assess the independent variables significance at 5% level (develop hypothesis if necessary in
the analysis)?
ANSWER:](/v2/_next/image?url=https%3A%2F%2Fcontent.bartleby.com%2Fqna-images%2Fquestion%2F45ec0afe-b7c9-45c8-bd67-2221f08741f3%2F1086ea20-7bba-4537-9b40-86f0d2a6c3e8%2Faw53tc_processed.jpeg&w=3840&q=75)
![Yummy Lunch Restaurant needs to decide the most profitable location for their business expansion.
Marketing manager plans to use a multiple regression model to achieve their target. His model
considers yearly revenue as the dependent variable. He found that number of people within 2KM
(People), Mean household income(income), no of competitors and price as explanatory variables of
company yearly revenue.
The following is the descriptive statistics and regression output from Excel.
Revenue
People
Income
Competitors
Price
343985.68
5307.89863
5970.28
139.0845281
41522.08
2.8
0.142857
Mean
5.88
Standard Error
582.1378385
41339.5
0.051030203
Median
345186.5
8032
3
5.75
#N/A
5917
Mode
Standard Deviation
Sample Variance
#N/A
3
983.47613
967225.2984
37532.51115
4118.334718
1.010153
0.380838027
0.130204082
284
1408689393
16944211.51
1.020408
Sum
17198284
298513
2076148
140
Count
50
50
50
50
50
SUMMARY
OUTPUT
Regression Statistics
0.77
Multiple R
R Square
Adjusted R Square
Standard Error
A
B
25139.79
Observations
50.00
ANOVA
Significance
of
MS
F
40585378295
Regression
Residual
Total
H
3.0831E-08
28440403984
G
E
69025780279
t Stat
-0.8706
P-value
0.3886
0.0891
0.0000
0.0857
0.1251
Coefficients
Standard Error
78524.7251
3.7051
0.9358
3818.5426
-88363.1524
Intercept
People
8.4394
7.2723
-6709.4320
Income
Competitors
Price
K
12ivate Wind
15988.7048
10219.0263
L
Go to Settings to](/v2/_next/image?url=https%3A%2F%2Fcontent.bartleby.com%2Fqna-images%2Fquestion%2F45ec0afe-b7c9-45c8-bd67-2221f08741f3%2F1086ea20-7bba-4537-9b40-86f0d2a6c3e8%2Frn9n2ej_processed.png&w=3840&q=75)
![](/static/compass_v2/shared-icons/check-mark.png)
Step by step
Solved in 3 steps
![Blurred answer](/static/compass_v2/solution-images/blurred-answer.jpg)
![MATLAB: An Introduction with Applications](https://www.bartleby.com/isbn_cover_images/9781119256830/9781119256830_smallCoverImage.gif)
![Probability and Statistics for Engineering and th…](https://www.bartleby.com/isbn_cover_images/9781305251809/9781305251809_smallCoverImage.gif)
![Statistics for The Behavioral Sciences (MindTap C…](https://www.bartleby.com/isbn_cover_images/9781305504912/9781305504912_smallCoverImage.gif)
![MATLAB: An Introduction with Applications](https://www.bartleby.com/isbn_cover_images/9781119256830/9781119256830_smallCoverImage.gif)
![Probability and Statistics for Engineering and th…](https://www.bartleby.com/isbn_cover_images/9781305251809/9781305251809_smallCoverImage.gif)
![Statistics for The Behavioral Sciences (MindTap C…](https://www.bartleby.com/isbn_cover_images/9781305504912/9781305504912_smallCoverImage.gif)
![Elementary Statistics: Picturing the World (7th E…](https://www.bartleby.com/isbn_cover_images/9780134683416/9780134683416_smallCoverImage.gif)
![The Basic Practice of Statistics](https://www.bartleby.com/isbn_cover_images/9781319042578/9781319042578_smallCoverImage.gif)
![Introduction to the Practice of Statistics](https://www.bartleby.com/isbn_cover_images/9781319013387/9781319013387_smallCoverImage.gif)