Question

A local ice cream store has been keeping track of it sales on a randomly selected day during each month. Using SPSS determine if there is a predictable relationship between ice cream sales and the temperature on that day.

Temperature °C	Ice Cream Sales
14.2°	$215
16.4°	$325
11.9°	$185
15.2°	$332
18.5°	$406
22.1°	$522
19.4°	$412
25.1°	$614
23.4°	$544
18.1°	$421
22.6°	$445
17.2°	$408

Answer 1

The null and alternative hypotheses are: Ho: B1 = 0 H1: B1 * 0 The value of test statistic is: t= 10.499 P-value = 0.000 Conclusion: The p-value of t-test is less than 0.05. Hence we reject null hypothesis at 5% level of significance and conclude that there is a predictable relationship between ice cream sales and the temperature on that day.

Model Summary Model R .958 R Square .917 Adjusted R Square .909 Std. Error of the Estimate 38.12650 1 a. Predictors: (Constant), Temperature °C ANOVA Mean Square 160218.616 F 110.220 Sig. .000 1 1 1453.630 Sum of Model Squares df Regression 160218.616 Residual 14536.300 10 Total 174754.917 11 a. Dependent Variable: Ice Cream Sales b. Predictors: (Constant), Temperature °C Coefficients Standardized Coefficients Unstandardized Coefficients + Beta Model B (Constant) -159.474 Temperature °C 30.088 a. Dependent Variable: Ice Cream Sales Std. Error 54.641 2.866 -2.919 10.499 Sig. .015 .000 .958