Question No 1: Month Rainfall (MM) X Umbrellas Sold Y
Question No 1: Month Rainfall (MM) X Umbrellas Sold Y
Question No 1: Month Rainfall (MM) X Umbrellas Sold Y
Month X Y
Jan 82 15
Feb 92.5 25
Rainfall (mm) X
180
160
140
120
100
80
60
40
20
0
1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22
60
40
20
0
1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22
Question No 5
Find the Correlation Coefficient between Rainfall (mm) and Umbrellas
(Sold). Interpret the main results
Column 1 1
Column 2 0.957667 1
The value of correlation 0.958 is closer to 1 so, it has strong positive relation.
mc200400852
Question No 2
• Find the Descriptive Statistics of the Umbrellas (Sold). I
main results.
tion No 1
ve Statistics of the Rainfall(mm). Interpret Mean 32.29167
the main results Standard E 2.483627
Median 31
Mode 20
Standard D 12.16724
Sample Var 148.0417
Kurtosis -1.359593
Skewness -0.048423
Range 36
Minimum 14
Maximum 50
Sum 775
Count 24
Question No 4
Find the Graph of Umbrellas (Sold)
Umbrellas sold Y
(mm) X
60
50
40
30
20
10
0
1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22
12 13 14 15 16 17 18 19 20 21 22 23 24 25
10
0
1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22
12 13 14 15 16 17 18 19 20 21 22 23 24 25
Question No 6
Consider Rainfall (mm) as Independent Variable (X) and Umbrellas (Sold) as Dependent Va
Analysis
SUMMARY OUTPUT
Regression Statistics
g positive relation. Multiple R 0.957667
R Square 0.917126
Adjusted R Square 0.913359
Standard Error 3.581414
Observations 24
ANOVA
df SS MS
Regression 1 3122.775 3122.775
Residual 22 282.1835 12.82652 F Significance F
Total 23 3404.958 243.4623 2.216E-13
Coefficients
Standard Error t Stat
Intercept -19.07411 3.372182 -5.65631
X Variable 1 0.450001 0.02884 15.60328 P-value Lower 95%
1.093E-05 -26.06759
2.216E-13 0.39019
tics of the Umbrellas (Sold). Interpret the
main results.
Umbrellas sold Y
13 14 15 16 17 18 19 20 21 22 23 24 25
13 14 15 16 17 18 19 20 21 22 23 24 25
Significance F