Domestic Profit (S Millions)

56.459076

-0.326515

0.63409

10.271091

-8.590472

11.590086

23.644

-4.480274

-5.214578

12.571189

16.21817

-0.340882

-16.694886

-33

-87.810116

-2.376918

-0.785353

-2.884121

116.340892

122.833357

-69.477903

4.342592

3.383834

9.235901

-8.444012

-9.868281

-11.382133

-55.967234

6.468807

-0.206742

-50.61305

-26.919996

98.41715

0.475636

99.928762

113.394119

62.805434

-60.98931

91.525503

-22.310393

2.367005

42.062868

-27.706594

48.002019

-14.96932

0.180155

50.418803

-1.901567

-2.762815

-1.120698

42.062868

-47.399769

-25.224407

33.846344

-0.025318

60.206105

-62.92908

61.848418

13.401785

23.237389

-0.0014

-66.996985

20.000304

25.241649

-10.770347

14.936517

-0.355548

-7

0.339192

-11.877442

-4.635511

-99.925825

-13.9

22.59288

25.853424

0.042482

30.165972

-31.552388

47.383924

61.407328

-17.47694

12.734552

54.502303

-13.9

-15

-15.559345

122.784257

82.185401

46.282411

22.298285

-9.258013

45.85601

-3.471316

-28.716745

117.730019

109.202565

19.219978

-0.232516

-19.260198

-19.417976

corresponding years with profits:

2005

2003

2012

1981

2008

2013

1981

2007

2012

2015

2009

2002

1986

1986

2010

2007

2004

2008

1993

1994

2013

1998

2001

2001

2000

2006

2010

2016

2000

2001

2010

2017

2001

1999

1994

2013

2012

1999

2012

2009

2010

2005

2008

2009

2011

2015

2002

2005

2013

2004

2005

2014

2008

1980

2002

2015

2005

2011

1996

2008

2015

2016

2015

2008

2011

2008

2001

1987

1999

2009

2011

2015

1995

1982

2011

1999

2006

1996

2003

2014

2013

2001

2004

1995

2014

2010

2005

2017

1994

2013

1999

2014

1998

2006

2009

2014

2010

2008

2008

2010

the domestic profits are movies before and after 2000. the first 23 cells are movies before 2000 and the remainding are 2000 and onward

AutoSave OFF Insert Draw lome Page Layout Formulas Data Review View Et Get Add-ins v b? Pictures Shapes Icons ivot Table Recommended Table Pivot Tables My Add-ins Recomme Chart: 12 X V fox A B D NOTE: If any of the assumptions are not met, still run your hypothesis test. 5 3 2h) Calculate (use Excel worksheets) the critical value for the rejection region. Round to two decimal places 3 9 0 21) Calculate the test statistic. I'd use the Excel worksheets, but don't let me tell you how to live your life. Round to three decimal places 32 83 2j) Calculate the P-value for your test statistic. Round to 4 decimal places. If you get something like 18-05, just write 0. 34 35 36 2K) Based on the test above, we should the nwl hypothesis 37 38 39 21) Summarize your findings in English that a non-statistics minor would understand. 40 42 AutoSave OFF Insert Draw lome Page Layout Formulas Data Review View Et Get Add-ins v b? Pictures Shapes Icons ivot Table Recommended Table Pivot Tables My Add-ins Recomme Chart: 12 X V fox A B D NOTE: If any of the assumptions are not met, still run your hypothesis test. 5 3 2h) Calculate (use Excel worksheets) the critical value for the rejection region. Round to two decimal places 3 9 0 21) Calculate the test statistic. I'd use the Excel worksheets, but don't let me tell you how to live your life. Round to three decimal places 32 83 2j) Calculate the P-value for your test statistic. Round to 4 decimal places. If you get something like 18-05, just write 0. 34 35 36 2K) Based on the test above, we should the nwl hypothesis 37 38 39 21) Summarize your findings in English that a non-statistics minor would understand. 40 42