Temperature Price of ice cream Units sold
20 ₹ 10.00 12
26 ₹ 20.00 15
30 ₹ 25.00 10
35 ₹ 30.00 20
38 ₹ 35.00 25 Temperature
40 ₹ 50.00 20
45 ₹ 60.00 10 Mean 33.428571429
Standard Error 3.2649447079
Median 35
Mode #N/A
Standard Deviation 8.6382317415
Sample Variance 74.619047619
Kurtosis -0.711762504
Skewness -0.339979528
Range 25
Minimum 20
Maximum 45
Sum 234
Count 7
Price of ice cream Units sold Temperature
Mean 32.857142857 Mean 16 Mean
Standard Error 6.5335346352 Standard Error 2.193063 Standard Error
Median 30 Median 15 Median
Mode #N/A Mode 10 Mode
Standard Deviation 17.286107827 Standard Deviation 5.802298 Standard Deviation
Sample Variance 298.80952381 Sample Variance 33.66667 Sample Variance
Kurtosis -0.521925049 Kurtosis -1.314871 Kurtosis
Skewness 0.4729404032 Skewness 0.430011 Skewness
Range 50 Range 15 Range
Minimum 10 Minimum 10 Minimum
Maximum 60 Maximum 25 Maximum
Sum 230 Sum 112 Sum
Count 7 Count 7 Count
Largest(1)
Smallest(1)
Temperature Price of ice cream Units sold
33.428571428571 Mean 32.8571428571429 Mean 16
3.2649447078899 Standard Error 6.53353463524393 Standard Error 2.193062655175
35 Median 30 Median 15
#N/A Mode #N/A Mode 10
8.6382317414531Standard Deviation 17.2861078270825 Standard Deviation 5.802298395176
74.619047619048 Sample Variance 298.809523809524 Sample Variance 33.66666666667
-0.711762504332 Kurtosis -0.52192504880875 Kurtosis -1.31487109107
-0.339979528297 Skewness 0.472940403158452 Skewness 0.430010546687
25 Range 50 Range 15
20 Minimum 10 Minimum 10
45 Maximum 60 Maximum 25
234 Sum 230 Sum 112
7 Count 7 Count 7
45 Largest(1) 60 Largest(1) 25
20 Smallest(1) 10 Smallest(1) 10
Temperature Price of ice cream Units sold
20 ₹ 10.00 12
26 ₹ 20.00 15 SUMMARY OUTPUT
30 ₹ 25.00 10
35 ₹ 30.00 20 Regression Statistics
38 ₹ 35.00 25 Multiple R 0.671408
40 ₹ 50.00 20 R Square 0.450788
45 ₹ 60.00 10 Adjusted R Square 0.176183
Standard Error 5.266421
Observations 7
ANOVA
df SS MS
Regression 2 91.05926 45.52963
Residual 4 110.9407 27.73518
Total 6 202
Coefficients
Standard Error t Stat
Intercept -13.76296 16.61066 -0.828562
Temperature 1.619581 0.905628 1.788351
Price of ice cream -0.741918 0.452561 -1.639376
RESIDUAL OUTPUT
ObservationPredicted Units sold
Residuals
Standard Residuals
1 11.20947 0.790528 0.183843
2 13.50778 1.492224 0.347028
3 16.27651 -6.276508 -1.459648
4 20.66482 -0.664821 -0.154609
5 21.81397 3.186027 0.740934
6 13.92436 6.075636 1.412934
7 14.60309 -4.603087 -1.070482
Temperature Residual Plot
10
5
Residuals
0
-5 15 20 25 30 35 40 4
-10
Temperature
F Significance F
1.641584 0.301633
Price of ice cream Residua
Plot
10
P-value Lower 95%Upper 95%Lower 95.0%
Upper 95.0%
Residuals
5
0.453928 -59.88155 32.35563 -59.88155 32.35563 0
0.148235 -0.894845 4.134006 -0.894845 4.134006 -5₹ - ₹ 20.00 ₹ 40.00 ₹ 60.00
-10
0.176478 -1.998429 0.514593 -1.998429 0.514593
Price of ice cream
PROBABILITY OUTPUT
Temperature Line Fit Plot
ndard Residuals Percentile Units sold 30
7.142857 10 20
Units sold
21.42857 10 Units sold
10 Predicted
35.71429 12
50 15 0
64.28571 20 15 20 25 30 35 40 45 50
78.57143 20 Temperature
92.85714 25
ture Residual Plot Normal Probability Plot
30
20
Units sold
25 30 35 40 45 50 10
0
0 10 20 30 40 50 60 70 80 90 100
Temperature
Sample Percentile
ce cream Residual
Plot Price of ice cream Line Fit
Plot
30
Units sold
Units sold
20
0.00 ₹ 40.00 ₹ 60.00 ₹ 80.00 Predicted Units sold
10
0
Price of ice cream ₹- ₹ 50.00 ₹ 100.00
Price of ice cream
ature Line Fit Plot
Units sold
Predicted Units sold
0 35 40 45 50
erature
ot
80 90 100
Fit
s sold
icted Units sold
Temperature Price of ice cream Units sold
20 ₹ 10.00 12
26 ₹ 20.00 15
30 ₹ 25.00 10
35 ₹ 30.00 20 Periodic Sampling Random Sampling
38 ₹ 35.00 25 26 30
40 ₹ 50.00 20 35 26
45 ₹ 60.00 10 40 35
30 45
40 26
45
26
Temperature
20
26
30 Bins
35 20
38 30
40 40 Bin Frequency Bin Frequency
45 50 20 2 40 5
20 30 3 30 3
22 40 5 50 3
34 50 3 20 2
36 More 0 More 0
42
46
Histogram
6 5
Frequency
4 3 3
2 Column H
2
0
0
40 30 50 20 More
Bin
Temperature Price of ice cream Units sold
20 ₹ 10.00 12
26 ₹ 20.00 15
30 ₹ 25.00 10
35 ₹ 30.00 20
38 ₹ 35.00 25
40 ₹ 50.00 20 Temperature
45 ₹ 60.00 10 Price of ice cream
Units sold
Correlation of
Temp. and
Units sold 0.285971
Correlation of
Temp. and Correlation
Price of ice of Temp. and
cream 0.961493 Units sold 0.1080102146155
Temperature Price of ice cream Units sold
1
0.9614926156 1
0.2859711952 0.1080102146155 1
Temperature Price of ice cream Units sold
20 ₹ 10.00 12
26 ₹ 20.00 15
30 ₹ 25.00 10
35 ₹ 30.00 20
38 ₹ 35.00 25 Anova: Single Factor
40 ₹ 50.00 20
45 ₹ 60.00 10 SUMMARY
Groups Count Sum Average
Column 1 7 234 33.42857
Column 2 7 230 32.85714
Column 3 7 112 16
ANOVA
Source of VariationSS df MS
Between G 1372.571 2 686.2857
Within Gro 2442.571 18 135.6984
Total 3815.143 20
Variance
74.61905
298.8095
33.66667
F P-value F crit If F > F crit, then we reject the null hypothesis
5.057434 0.018073 3.554557
Temperature Price of ice cream Units sold
20 ₹ 20.00 20
26 ₹ 26.00 26
30 ₹ 30.00 30
35 ₹ 35.00 35
38 ₹ 38.00 38 Anova: Single Factor
40 ₹ 40.00 40
45 ₹ 45.00 45 SUMMARY
Groups Count
Column 1 7
Column 2 7
Column 3 7
ANOVA
Source of Variation SS
Between Groups 6.8212103E-13
Within Groups 1343.1428571
Total 1343.1428571
Sum Average Variance
234 33.428571429 74.619047619
234 33.428571429 74.619047619
234 33.428571429 74.619047619
df MS F P-value F crit
2 3.4106051E-13 4.5706897E-15 1 3.5545571
18 74.619047619
20