Question
A business owner wants to predict sales given an investment of $10,000 in her company.The data below show her investments and sales for previous quarters.
A business owner wants to predict sales given an investment of $10,000 in her company.The data below show her investments and sales for previous quarters.
Investment (in thousands of $) Sales (in thousands of $)
8 20
15 40
4 13
7 15
12 30
6 14
11 24
1)Which variable is the independent variable and which is the dependent variable
a.Independent__________________(1 point)
b.Dependent__________________(1 point)
2)Calculate the Pearson's r
a.What is the value of SP?_________________(1 point)
b.What is the value of SSx?___________________ (1 point)
c.What is the value of SSy ?____________________(1 point)
d.What is the value of r?___________________(1 points)
3)Describe the relationship between these two variables.In other words, from a substantive standpoint, what does your calculation of Pearson's r tell you? (2 points)
4)Is the correlation between these two variables significantly different from zero?Explain how you know. (2 points)
5)Using regression, calculate the linear relationship between these variables.Report your results in a linear regression equation.(5 points)
6)How much of the dependent variable's variance is explained by the independent variable? (i.e. What is the value of r-squared) (2 points)
7)Calculate the F-statistics.Is the result statistically significant?
a.What is the value of SStot ?___________________ (1 point)
b.What is the value of SSreg ?____________________(1 point)
c.What is the value of SSerror ?___________________(1 points)
d.What is the value of df tot?___________________ (1 point)
e.What is the value of df reg ?____________________(1 point)
f.What is the value of df error ?___________________(1 points)
g.What is the value of MSreg ?___________________(1 points)
h.What is the value of MS error ?___________________(1 points)
i.What is the value of the F-statistic? ______________(1 points)
j.Is F statistically significant?YESNO(1 points)
8)Finally, based on the data below, what would you predict her sales will be given an investment of $10,000? (3 points)
Can I get some help with this please. I'm confused
Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started