Question No 1: Month Rainfall (MM) X Umbrellas Sold Y

Download as xlsx, pdf, or txt
Download as xlsx, pdf, or txt
You are on page 1of 6

Rainfall (mm) Umbrellas sold mc200400852

Month X Y
Jan 82 15
Feb 92.5 25

Mar 83.2 17 Question No 1


Apr 97.7 28 Find the Descriptive Statistics of the Rainfall(mm).
May 131.9 41 the main results
Jun 141.3 47 Mean 114.1458
Jul 165.4 50 Standard E 5.285511
Aug 140 46 Median 103.65
Sep 126.7 37 Mode #N/A
Oct 97.8 22 Standard D 25.89361
Nov 86.2 20 Sample Var 670.4791
Dec 99.6 30 Kurtosis -1.062046
Jan 87 14 Skewness 0.495772
Feb 97.5 27 Range 83.4
Mar 88.2 14 Minimum 82
Apr 102.7 30 Maximum 165.4
May 123 43 Sum 2739.5
Jun 146.3 49 Count 24
Jul 160 49
Aug 145 44
Sep 131.7 39 Mean>Median (which shows that the disribution is positively
Oct 118 36
Nov 91.2 20 Question No 3
Dec 104.6 32 Find the Graph of Rainfall (mm)

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

Mean>Median>Mode(which shows that distribution is posi

that the disribution is positively skewed)

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.

hows that distribution is positively skewed)

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

ellas (Sold) as Dependent Variable (Y), perform the Regression


lysis

Significance F

Upper 95%Lower 95.0%


Upper 95.0%
-12.08063 -26.06759 -12.08063
0.509812 0.39019 0.509812

You might also like