aima assignment gm03 solution nov 12

13
SUPPOSE THE DATA IS AS FOLLOWS DAYS DAY AMOUNT SPENT 7 DAY MOVING AVERAGE 1 MON 42 2 TUE 37 3 WED 77 4 THU 67 5 FRI 92 6 SAT 52 7 SUN 92 8 MON 82 65.57 9 TUE 47 71.29 10 WED 47 72.71 11 THU 50 68.43 12 FRI 35 66.00 13 SAT 95 57.86 14 SUN 65 64.00 15 MON 110 60.14 16 TUE 70 64.14 17 WED 95 67.43 18 THU 85 74.29 19 FRI 60 79.29 20 SAT 60 82.86 21 SUN 42 77.86 22 MON 37 74.57 23 TUE 77 64.14 24 WED 67 65.14 25 THU 92 61.14 26 62.14 ←FORECAST FOR 26 TH

Upload: abhimit-kumar

Post on 28-Oct-2014

69 views

Category:

Documents


1 download

TRANSCRIPT

Page 1: Aima Assignment Gm03 SOLUTION NOV 12

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

Page 2: Aima Assignment Gm03 SOLUTION NOV 12

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

Page 3: Aima Assignment Gm03 SOLUTION NOV 12

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

Page 4: Aima Assignment Gm03 SOLUTION NOV 12

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

Page 5: Aima Assignment Gm03 SOLUTION NOV 12

THE SALES OF CHOCLATE HAS DECREASED FROM 984.7

Page 6: Aima Assignment Gm03 SOLUTION NOV 12

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

Page 7: Aima Assignment Gm03 SOLUTION NOV 12

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

Page 8: Aima Assignment Gm03 SOLUTION NOV 12

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

Page 9: Aima Assignment Gm03 SOLUTION NOV 12

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

Page 10: Aima Assignment Gm03 SOLUTION NOV 12

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 ( %

)