aima assignment gm03 solution nov 12
TRANSCRIPT
SUPPOSE THE DATA IS AS FOLLOWSDAYS DAY AMOUNT SPENT 7 DAY MOVING AVERAGE
1 MON 422 TUE 373 WED 774 THU 675 FRI 926 SAT 527 SUN 928 MON 82 65.579 TUE 47 71.29
10 WED 47 72.7111 THU 50 68.4312 FRI 35 66.0013 SAT 95 57.8614 SUN 65 64.0015 MON 110 60.1416 TUE 70 64.1417 WED 95 67.4318 THU 85 74.2919 FRI 60 79.2920 SAT 60 82.8621 SUN 42 77.8622 MON 37 74.5723 TUE 77 64.1424 WED 67 65.1425 THU 92 61.1426 62.14 ←FORECAST FOR 26 THE DAY
NULL HYPOTHESIS :- THE QULALITY OF FOOD SERVED IS SAME
ALTERNATE HYPOTHESIS :- THE QULALITY OF FOOD SERVED IS DIFFERENT
Honey Chicken Anova: Single Factor6 8 7 6
7 8 6 6 SUMMARY8 9 6 7 Groups Count Sum5 8 6 6 Chicken Platter 7 509 7 5 8 Honey Chicken 7 578 9 7 7 Chicken Spinach 7 447 8 7 6 Tandoori Chicken 7 46
ANOVASource of Variation SS df
Between Groups 14.107142857 3Within Groups 20.857142857 24
Total 34.964285714 27
NULL REJECTED :- WHICH MEANS THAT THE QUALITY OF FOOD SERVED IS DIFFERENT.
Chicken Platter
Chicken Spinach
Tandoori Chicken
Average Variance7.142857 1.8095248.142857 0.476196.285714 0.5714296.571429 0.619048
MS F P-value F crit4.702381 5.410959 0.005478 3.0087870.869048
QS3
NULL HYPOTHESIS :- THE SALES OF CHOCLATE IS 984.7
ALTERNATE HYPOTHESIS :- THE SALES OF CHOCLATE HAS DECREASED FROM 984.7
Data984.7
Level of Significance 0.02Population Standard Deviation 72.6Sample Size 30Sample Mean 912.1
Intermediate CalculationsStandard Error of the Mean 13.254885892Z Test Statistic -5.477225575
Lower-Tail TestLower Critical Value -2.053748911
2.160232E-08Do not reject the null hypothesis
NULL ACCEPTED :- WHICH MEANS THAT THE SALES OF CHOCHOLATE IS STILL 984.7
Null Hypothesis m=
p-Value
THE SALES OF CHOCLATE HAS DECREASED FROM 984.7
chi square test
Observed FrequenciesColumn variable Calculations
Gender Baseball Basketball Football Total fo-feMen 19 15 24 58 0.203704 -2.722222
Women 16 18 16 50 -0.203704 2.722222Total 35 33 40 108
Expected FrequenciesColumn variable
Gender Baseball Basketball Football Total (fo-fe)^2/feMen 18.7963 17.72222 21.48148 58 0.002208 0.418147
Women 16.2037 15.27778 18.51852 50 0.002561 0.485051Total 35 33 40 108
DataLevel of Significance 0.05Number of Rows 2Number of Columns 3Degrees of Freedom 2
ResultsCritical Value 5.991465 NULL HYPOTHESIS :- THERE IS NO ASSOCIATION BETWEEN GENDER AND TYPE OF SPORTSChi-Square Test Statistic 1.545759
0.461682 ALTERNATE HYPOTHESIS :- THERE IS AN ASSOCIATION BETWEEN GENDER AND TYPE OF SPORTSDo not reject the null hypothesis
Expected frequency assumption is met. NULL ACEEPTED :- WHICH MEANS THAT THERE IS NO ASSOCAITION BETWEEN GENDER AND TYPE OF SPORTS OR SPORT WEAR IS NOT GENDER SPECIFIC
p-Value
fo-fe2.518519
-2.518519
(fo-fe)^2/fe0.2952750.342519
THERE IS NO ASSOCIATION BETWEEN GENDER AND TYPE OF SPORTS
THERE IS AN ASSOCIATION BETWEEN GENDER AND TYPE OF SPORTS
NULL ACEEPTED :- WHICH MEANS THAT THERE IS NO ASSOCAITION BETWEEN GENDER AND TYPE OF SPORTS OR SPORT WEAR IS NOT GENDER SPECIFIC
X Y SUMMARY OUTPUTCompany Debt/Capital ( %) Return on Capital ( %)
Abbott Laboratories 11 31 Regression StatisticsAllergan 24 25 Multiple RCardinal Health 30 14 R SquareJohnson & Johnson 11 25 Adjusted R SquareEli Lilly 31 40 Standard ErrorMerck 15 33 ObservationsPfizer 7 23
SmithKline Beecham 10 22 ANOVABristol-Myers Squibb 12 45
Stryker 55 14 RegressionUnited Health 10 17 ResidualUniversal Health 38.6 9.8 Total
InterceptDebt/Capital ( %)
RESIDUAL OUTPUT
Observation123456789
101112
Regression Statistics0.4160204556554010.173073019523728
0.090380321476100510.2677443771688
12
df SS MS F Significance F1 220.6543 220.6543 2.092966 0.17858620038
10 1054.266 105.426611 1274.92
Coefficients Standard Error t Stat P-value Lower 95% Upper 95%Lower 95.0%Upper 95.0%31.3195866450732 5.336275 5.869185 0.000157 19.4296253407 43.20955 19.42963 43.20955
-0.302572819092218 0.209146 -1.446709 0.178586 -0.7685783366 0.163433 -0.768578 0.163433
Predicted Return on Capital ( %)Residuals27.9912856350588 3.008714
24.05783898686 0.94216122.2424020723067 -8.24240227.9912856350588 -2.99128621.9398292532145 18.06017
26.78099435869 6.21900629.2015769114277 -6.201577
28.293858454151 -6.29385827.6887128159666 17.3112914.6780815950012 -0.678082
28.293858454151 -11.2938619.6402758281136 -9.840276
Upper 95.0%
0 10 20 30 40 50 600
1020304050
Debt/Capital ( %) Line Fit Plot
Return on Capital ( %)Predicted Return on Capital ( %)
Debt/Capital ( %)
Retu
rn o
n Ca
pita
l ( %
)