Benrahou, Khaliss, Yacoubi Soussane.xlsx - these cases...

This preview shows page 1 - 6 out of 110 pages.

these cases studies are done by :Benrahou KenzaKhaliss OumaimaYacoubi Soussane Zakaria
MonthMicrosofCaterpillarSandiskQualcomm3-Jan-0.08201-0.02261-0.0304-0.00186-0.11443-0.248670.03493-Feb0.002110.002930.06867-0.01781-0.044240.09363-0.081783-Mar0.021520.027340.046810.103340.062450.008390.042513-Apr0.055760.007150.07622-0.026090.182570.43876-0.114443-May-0.037170.04119-0.00856-0.031410.095320.501650.053953-Jun0.04185-0.013460.06731-0.048760.177790.11640.071243-Jul0.03003-0.009190.218470.001740.043060.397340.042853-Aug0.004170.066610.06462-0.03804-0.025640.066330.104593-Sep0.04827-0.02918-0.04163-0.001210.049960.054090.008233-Oct-0.05396-0.000550.069870.016360.062020.264910.139673-Nov-0.01645-0.003550.0378-0.01570.04120.00273-0.060433-Dec0.064570.13260.091650.04787-0.03121-0.242760.210554-Jan0.01023-0.00512-0.054440.034070.03665-0.112750.086784-Feb-0.040510.03996-0.030460.013670.09946-0.063720.077634-Mar-0.06031-0.013750.04383-0.059170.009540.115660.050724-Apr0.048130.02308-0.012270.06526-0.0469-0.18371-0.057784-May0.003830.0228-0.030620.03637-0.030480.064790.075414-Jun0.088830.026820.05428-0.00018-0.01515-0.120080.088124-Jul-0.002450.04256-0.06974-0.007720.057690.12125-0.051664-Aug-0.038960.00151-0.010750.05636-0.01745-0.039880.101574-Sep0.012820.048370.1066-0.030460.037380.247110.026024-Oct0.011570.018420.006220.036390.03996-0.283310.065574-Nov0.068640.046730.13670.038110.073410.081940.000484-Dec-0.003360.00020.06510.051390.042940.105850.020425-Jan-0.016470.00663-0.082040.020180.01029-0.01081-0.12175-Feb-0.039570.232170.066780.018320.02130.08826-0.030085-Mar-0.03935-0.0586-0.037980.02378-0.058650.034230.016095-Apr0.04675-0.04312-0.032590.02189-0.05877-0.14748-0.04755-May0.02292-0.009470.06882-0.017490.055610.095780.070795-Jun-0.037210.02260.01275-0.0313-0.1031-0.08625-0.11435-Jul0.0310.022270.1365-0.0160.123240.42520.1965-Aug0.072240.024510.02931-0.003750.041070.148140.008115-Sep-0.060260.060770.05875-0.001740.032050.242340.126925-Oct-0.00117-0.11646-0.1006-0.01043-0.056430.22056-0.111515-Nov0.080160.038830.09869-0.008620.0924-0.132810.143615-Dec-0.05527-0.03205-0.00017-0.02672-0.003840.23032-0.05058SUMMARY OUTPUTmicrosofRegression StatisticsMultiple R 0.2659798R Square0.0707452 7.0745231Adjusted R0.0434142Standard Er0.0443758ExxonMobilJohnson &JohnsonMcDonald's
Observatio36ANOVAdfSSMSFSignificance FRegression1 0.0050972 0.00509722 2.58845896 0.1168925Residual34 0.0669531 0.00196921Total35 0.0720503Coefficientstandard Errot StatP-valueLower 95%Upper 95%Lower 95.0%Intercept0.0003984 0.0079355 0.05020969 0.96024911 -0.015728 0.0165253 -0.01572838S&P 5000.4583448 0.2848864 1.60886885 0.11689251 -0.120614 1.0373036 -0.12061396SUMMARY OUTPUTExxon MobilRegression StatisticsMultiple R 0.3477463R Square0.1209275Adjusted R0.0950724Standard Er0.0526437Observatio36ANOVAdfSSMSFSignificance FRegression10.012962 0.01296202 4.67712822 0.0376909Residual34 0.0942264 0.00277136Total35 0.1071884Coefficientstandard Errot StatP-valueLower 95%Upper 95%Lower 95.0%Intercept0.00925850.009414 0.98348493 0.33231598 -0.0098730.02839 -0.00987301S&P 5000.7309071 0.3379656 2.162666920.0376909 0.04407831.4177360.0440783SUMMARY OUTPUTCaterpillarRegression StatisticsMultiple R 0.5734138R Square0.3288034Adjusted R0.3090623Standard Er0.0569916Observatio36ANOVAdfSSMSFSignificance FRegression1 0.0540987 0.05409874 16.6557988 0.0002565Residual34 0.1104334 0.00324804Total35 0.1645322
Coefficientstandard Errot StatP-valueLower 95%Upper 95%Lower 95.0%Intercept0.0150229 0.0101915 1.47406424 0.14966385 -0.005689 0.0357345 -0.00568869S&P 5001.4932047 0.3658783 4.08115165 0.00025646 0.7496506 2.2367588 0.74965061SUMMARY OUTPUTJohnson & JohnsonRegression StatisticsMultiple R0.006613R Square4.37E-005Adjusted R -0.029367Standard Er0.0353742Observatio36ANOVAdfSSMSFSignificance FRegression1 1.86E-0061.861E-006 0.00148692 0.9694662Residual34 0.0425455 0.00125134Total35 0.0425473Coefficientstandard Errot StatP-valueLower 95%Upper 95%Lower 95.0%Intercept0.0052072 0.0063258 0.82316382 0.41615138 -0.007648 0.0180627 -0.00764837S&P 5000.008757 0.2270978 0.03856064 0.96946621 -0.452761 0.4702753 -0.45276127SUMMARY OUTPUTMcDonald'sRegression StatisticsMultiple R 0.5812103R Square0.3378055Adjusted R0.3183292Standard Er0.0562227Observatio36ANOVAdfSSMSFSignificance FRegression1 0.0548255 0.05482551 17.3444284 0.0002015Residual34 0.1074735 0.00316099Total35 0.1622991Coefficientstandard Errot StatP-valueLower 95%Upper 95%Lower 95.0%Intercept0.00929890.010054 0.92490069 0.36153591 -0.011133 0.0297311 -0.01113321S&P 5001.5032012 0.3609417 4.16466426 0.00020149 0.7696793 2.2367231 0.76967931SUMMARY OUTPUTSandisk
Regression StatisticsMultiple R 0.3509957R Square0.123198Adjusted R0.0974097Standard Er0.1856369Observatio36ANOVAdfSSMSFSignificance FRegression1 0.1646301 0.16463011 4.77728195 0.0358213Residual34 1.1716754 0.03446104Total35 1.3363055Coefficientstandard Errot StatP-valueLower 95%Upper 95%Lower 95.0%Intercept0.0429654 0.0331964 1.29427919 0.20429125 -0.024498 0.1104286 -0.02449779S&P 5002.6048362 1.1917632 2.18569942 0.03582133 0.1828819 5.0267904 0.18288192SUMMARY OUTPUTQualcommRegression StatisticsMultiple R 0.4319323R Square0.1865655Adjusted R0.162641Standard Er0.0788674Observatio36ANOVAdfSSMSFSignificance FRegression1 0.0485045 0.04850454 7.79808019 0.0085239Residual34 0.2114821 0.00622006Total35 0.2599866Coefficientstandard Errot StatP-valueLower 95%Upper 95%Lower 95.0%Intercept0.0140866 0.0141034 0.99880978 0.32494268 -0.014575 0.0427482 -0.01457495S&P 5001.4138944 0.5063177 2.79250429 0.008523910.384933 2.44285580.384933SUMMARY OUTPUT

Upload your study docs or become a

Course Hero member to access this document

Upload your study docs or become a

Course Hero member to access this document

End of preview. Want to read all 110 pages?

Upload your study docs or become a

Course Hero member to access this document

Term
Spring
Professor
Lahcen Layouni
Tags
Business, Normal Distribution, Regression Analysis, Standard Deviation, Variance, Mean, Errors and residuals in statistics

  • Left Quote Icon

    Student Picture

  • Left Quote Icon

    Student Picture

  • Left Quote Icon

    Student Picture