A clothes shop manager records the weekly sales figures, £s, and the average weekly temperature, t °C, for 6 weeks during the summer - Edexcel - A-Level Maths Statistics - Question 1 - 2017 - Paper 1
Question 1
A clothes shop manager records the weekly sales figures, £s, and the average weekly temperature, t °C, for 6 weeks during the summer. The sales figures were coded so... show full transcript
Worked Solution & Example Answer:A clothes shop manager records the weekly sales figures, £s, and the average weekly temperature, t °C, for 6 weeks during the summer - Edexcel - A-Level Maths Statistics - Question 1 - 2017 - Paper 1
Step 1
Find S_{ss} and S_{tt}
96%
114 rated
Only available for registered users.
Sign up now to view full answer, or log in if you already have an account!
Let ( S_{w} = 50, , \sum w = 42 ):
Sss=50−6(42)2=50−294=−244
Step 2
Write down the value of S_{ss} and the value of S_{tt}
99%
104 rated
Only available for registered users.
Sign up now to view full answer, or log in if you already have an account!
Answer
The value of S_{ss} is -244 and the value of S_{tt} is 93.1667.
Step 3
Find the product moment correlation coefficient between s and t
96%
101 rated
Only available for registered users.
Sign up now to view full answer, or log in if you already have an account!
Answer
The product moment correlation coefficient (r) can be calculated using:
r=(n∑w2−(∑w)2)(n∑t2−(∑t)2)n(∑wt)−∑w∑t
Substituting in the known values:
( n = 6, \sum wt = 784, \sum w = 42, \sum t = 119 ):
Calculate numerators and denominators:
r=(6)(50)−(42)2)(6)(2435)−(119)26(784)−(42)(119)
Calculate this to find the correlation coefficient r, approximately 0.8.
Step 4
State, giving a reason, whether or not your value of the correlation coefficient supports the manager's belief
98%
120 rated
Only available for registered users.
Sign up now to view full answer, or log in if you already have an account!
Answer
The value of the correlation coefficient, which is close to 1, indicates a strong positive correlation between sales and temperature. This supports the manager's belief that a linear regression model may be appropriate.
Step 5
Find the equation of the regression line of w on t, giving your answer in the form w = a + bt
97%
117 rated
Only available for registered users.
Sign up now to view full answer, or log in if you already have an account!
Answer
To find the regression line of w on t, we calculate:
Slope (b) = b=(n∑t2−(∑t)2)(n∑wt−∑w∑t)
Intercept (a) = a=wˉ−btˉ
Substituting calculated values gives:
Solve for a and b.
Step 6
Hence find the equation of the regression line of s on t, giving your answer in the form s = c + dt, where c and d are correct to 3 significant figures
97%
121 rated
Only available for registered users.
Sign up now to view full answer, or log in if you already have an account!
Answer
Using the values of a and b from the previous answer:
Convert the regression equation of w to s using:
s=1000(a+bt)
Calculate c and d rounded to 3 significant figures.
Step 7
Using your equation in part (f), interpret the effect of a 1°C increase in average weekly temperature on weekly sales during the summer
96%
114 rated
Only available for registered users.
Sign up now to view full answer, or log in if you already have an account!
Answer
According to the regression equation, a 1°C increase in average weekly temperature correlates with a predicted increase in sales. Specifically, the slope of the regression line indicates the expected change in sales for each degree increase in temperature, which can be interpreted as the direct effect on sales volume.