excel assignment Math guruu

At the beginning of this class, you collected some international “flight data” for two times of the year. You were asked if there appeared to be a difference. You now have the tools to answer that question statistically. Go back. Use that data. What do you conclude?

Use the data set “Birthweight_smoker” Is there a difference in birth weight for babies whose mother was a non-smoker vs a smoker? Be sure to include summary statistics and any figures that benefit the analysis. Your response can simply be a paragraph stating yes or no and what parameters indicate there is a statistically significant difference or why the parameters indicate there is not a statistically significant difference.

Use the data set “stkmrkt_season”and perform an ANOVA analysis to determine if there are differences in the months of the year. What is the conclusion? Your response can simply be a paragraph stating yes or no and what parameters indicate there is a statistically significant difference or why the parameters indicate there is not a statistically significant difference. Note: The data source for this is:

• C-C. Chien, C-F. Lee, A.M.L. Wang (2002). “A Note on Stock Market Seasonality: The Impact of Stock Price Volatility on the Application of Dummy Variable Regression Model,” The Quarterly Review of Economics and Finance, Vol. 42, pp. 155-162. 

There are three different data sets and each will need to be analyzed and results presented. Think about what you have studied to date (format data, plot data, which analysis to perform, user-friendly, present results and provide the correct evidence supporting your conclusion). Your submission will be on workbook but each data set must be presented and analyzed on a separate tab. Your conclusions/write-up should be a separate tab and include each of the write-ups. The write-ups can (should) be short; three sentences at the most. Include all write-ups on one tab.

8

0

5

1

2

17217

1

840943

1

237348

1

1

1

675767

1

1

1

1

1

1

1

1

1

1

1

1

1

1

6

1

1

1

1

1

1

1

1

1

1

1

1

1

1

1

2

2

2

2

2

2

2

2

2

2

2

2

2

2

2

2

2

2

2

2

2

2

2

2

2

2

2

2

2

2

2

2

2

2

2

2

3

3

3

3

3

3

3

3

3

3

3

3

945603

3

3

3

3

3

3

3

3

3

3

3

3

3

3

3

3

3

3

3

3

3

3

3

3

4

4

4

4

4

4

4

4

4

4

4

4

4

4

4

4

4

4

4

4

4

4

4

4

4

4

4

4

4

4

4

4

4

4

4

4

5

5

5

5

5

5

5

5

5

5

5

5

5

5

5

5

5

5

5

5

5

5

5

5

5

5

5

5

5

5

5

5

5

5

5

5

6

6

6

6

6

6

6

6

6

6

6

6

6

6

6

6

6

6

6

6

6

6

6

6

6

6

6

6

6

6

6

6

6

6

6

6

7

7

7

7

7

7

7

7

7

7

7

7

7

7

7

7

7

7

7

7

7

7

7

7

7

7

7

7

7

7

7

7

7

7

7

7

8

8

8

8

8

8

8

8

8

8

8

8

8

8

8

8

8

8

8

8

8

8

8

8

8

8

8

8

8

8

8

8

8

8

8

8

9

9

9

9

9

9

9

9

9

9

9

9

9

9

9

9

9

9

9

9

9

9

9

9

9

9

9

9

9

9

9

9

9

9

9 0.054
9

10

10

10

10

10

10

10

10

10

10

10

10

10

10

10

10

10

10

10

10

10

10

10

10

10

10

10

10

10

10

10

10

10

10

10

10

11

11

11

11

11

11

11

11

11

11

11

11

11

11

11

11

11

11

11

11

11

11

11

11

11

11

11

11

11

11

11

11

11

11

11

11

12

12

12

12

12

12

12

12

12

12

12

12

12

12

12

12

12

12

12

12

12

12

12

12

12

12

12

12

12

12

12

12

12

12

12

12

month	vwmr
																																			1	0.0 Save Time On Research and Writing Hire a Pro to Write You a 100% Plagiarism-Free Paper. Get My Paper																																				8																																				6																																				5																																				2																																				9
0.0																																				3																																				7
0.01																																				4
-0.0																																				10
-0.00541302
0.04962986
0.																																				12
0.006146815
-0.060963936
-0.024779683
0.028475084
-0.00273007
0.004823829
0.005246674
-0.059965979
0.005040938
0.060583307
0.052305072
0.044298696
-0.007376929
0.004075																																				11
-0.050323594
0.011583767
0.028308799
0.106997825
0.068788722
-0.012413152
0.033751972
-0.047073569
0.062100462
0.06723766
0.129515548
0.036950655
-0.011281445
0.1414
-0.0732
0.029098351
0.038238388
0.074419805
-0.01434395
0.033636267
0.039485709
0.006854789
0.017544606
-0.026200134
0.022511637
-0.015982699
0.033802703
-0.019613443
0.01755595
-0.020766884
-0.001020415
-0.043983578
0.011279138
0.039448329
0.013080813
-0.05099688
-0.013338813
0.061490387
0.066544429
-0.031564872
-0.004995616
0.018680995
0.01754802
-0.01200509
-0.024275867
0.001159948
0.040249181
0.007834205
-0.014275405
0.0757
-0.0524
-0.003231685
0.056769574
-0.001605768
0.032664051
0.052729228
0.023615805
-0.000891056
0.009918868
-0.002889188
0.045819355
0.00681647
	0.054
-0.004852615
-0.00727402
0.015105028
0.01173667
-0.003233874
-0.033731854
0.011903123
-0.00924104
0.041710098
-0.015927397
0.042952501
-0.007328556
0.019334124
0.036502007
-0.003638576
0.0267528
0.008560349
-0.021096387
0.003403297
0.056922451
0.004987699
-0.012107083
0.0656
-0.1201
0.009133414
0.020237393
0.038307824
0.04376018
0.013600427
0.044356051
-0.011395438
-0.057071442
-0.00293874
-0.004215499
-0.056248329
0.026952716
-0.01195951
0.004160989
-0.03517908
0.026520668
0.065359359
-0.014685235
0.007441476
0.067020949
0.037686144
0.065990408
0.010543618
0.006293946
-0.004035604
0.052160148
-0.026471264
0.019577584
0.009356103
0.07578265
-0.00687984
-0.032929903
0.017418946
0.00954889
0.0941
-0.1053
-0.006349846
0.009157479
-0.037515773
0.001812185
-0.013016646
-0.063423666
0.001842605
-0.006920079
0.051457506
-0.009371212
0.031304801
0.016776529
-0.031530182
0.024883667
0.008067058
0.017597091
0.034824906
0.015772695
0.067290775
0.015828392
-0.032130346
0.037760447
-0.031041382
-0.05541352
-0.016580242
-0.014295008
-0.009491569
0.068047174
0.069057084
0.037208087
-0.032824955
0.012592504
0.028839884
0.006983558
0.0889
-0.0845
0.033996787
-0.022317837
0.004835248
0.046236476
0.038473628
-0.05121938
0.031061859
-0.010772396
-0.020031873
-0.035499829
-0.009838849
0.022682506
0.04695248
0.004811987
-0.002078108
-0.006280685
0.031301415
-0.03484941
0.008423855
0.033506102
0.03481383
0.013854142
-0.037488064
-0.026394144
-0.023124088
-0.046619375
0.001597509
0.040050497
-0.079237274
0.024949241
-0.006291273
-0.024705394
0.025326998
0.021373419
0.0516
-0.0827
-0.006009166
0.066040667
0.005199458
-0.027765819
0.069638398
0.002310955
0.032104551
0.053785671
0.02668766
0.060575595
-0.018984957
0.071926837
-0.05824734
-0.02600218
-0.011206106
0.019975031
-0.006906482
0.033291087
0.027086533
0.036933962
0.067507506
-0.043119744
0.048009606
0.001006375
-0.019448517
-0.056502328
-0.021196008
-0.000287653
-0.062711784
-0.002591495
0.030513567
-0.038276006
0.010921788
-0.040059659
0.0771
-0.0709
0.000137618
0.032904008
-0.073534718
0.081768543
-0.038497508
0.034481859
0.073899532
-0.030745798
-0.021455574
0.037293492
-0.026372928
-0.031206093
0.05666076
0.063076148
-0.005932548
0.080892511
0.067829248
-0.000448707
-0.026246773
-0.021379457
0.050461201
0.020620664
0.024160538
0.001486458
0.008257566
-0.014984243
0.041225539
-0.009360204
0.070879556
0.022239237
0.036140146
0.053008803
0.000301385
-0.05926026
0.119
-0.0917
-0.007104741
-0.043881161
0.021271336
0.0152748
-0.033676456
-0.00555404
0.042847883
0.042414666
-0.039490278
0.026919274
0.004756603
0.013346199
-0.028035744
-0.006204008
-0.066972458
-0.023667722
-0.009471178
0.043377233
-0.034156282
0.010497226
0.003546781
-0.044158906
0.009867121
0.052478811
0.031449628
0.037731868
-0.006420941
0.032033856
-0.077226665
-0.040543847
-0.005145784
0.004155291
0.017561022
0.024280611
-0.1097
-0.008442866
-0.009355277
-0.003782697
-0.01273052
0.005673888
0.047878098
0.030436217
-0.007576321
-0.018232149
0.006526596
0.002166304
0.062269191
-0.084681324
-0.030066339
0.037082883
0.038825002
-0.016487687
0.002135263
0.086591631
-0.035343712
0.085784415
0.024271317
0.055121904
-0.011236265
-0.036246287
0.027695435
0.02866594
-0.006977877
-0.02600441
0.06566691
-0.045366066
0.071109355
-0.014117057
-0.068353494
0.1656
-0.2249
0.027761704
0.028627216
-0.068254517
0.03832102
0.025458624
-0.027961387
0.005440516
0.094143885
0.044463424
-0.036563243
0.017224017
0.082307143
0.014917744
-0.006461295
0.0594283
-0.004647018
0.004576502
0.047282276
0.083576754
-0.018800475
0.004645295
0.010928393
0.048788634
0.074192429
0.080116161
0.004710666
0.050246172
-0.020697477
-0.007498581
-0.033407393
-0.029613054
0.036881798
0.042482901
0.022182864
0.1101
-0.1209
0.056382775
0.044657683
-0.026295999
-0.029770682
0.013579323
0.01575871
0.029554151
-0.027838248
0.004149611
0.020939478
-0.033067642
0.016524898
0.062478179
-0.029155553
0.047151427
0.039681524
0.039775825
0.049853096
0.012071626
0.016910616
-0.014988895
0.025404049
0.045644443
0.016665422
0.042990819
0.044791124
-0.02306595
0.020569862
-0.001206353
0.007074266
0.007062637
-0.018560609
0.036718113
-0.012939723
0.1071
-0.0342

3

12

1

13

.4

0

12

1

13 18 5.8 1

13 19

0

12 19

1

5

12 19

1

13 19

0

81

21 8 0

14

0

14 20

0

13 20

1

13 19 7 1

13 19 6.6 0

13 21

0

57 14 20

1

2

14 20

1

13 19

1

13 20 7.5 1

22

13 19 6 1

13 20

0

14 21

0

13 20

0

14 20

0

14 20

1

13 21

1

14 19 7.3 1

14 21 8 1

12 20 6 1

15 22 9 0

13 21 7 0

13 21 7.3 0

27 14 20

1

13 21 7 1

13 20 6.9 1

15 22 10 1

14 21 8.6 0

13 21 8 0

13 22 10 0

13 19 8.5 1

14 20

0

id	headcirumference	length	Birthweight	smoker
																						1																					13						12	1			7		5.			8																				0
431											1	9	4.2
808	19			6
300		18	4.5
516
3										21	6.8
1363	5.2
	57	6.1
8			22		7.5
		10													14
1636														20		8.6
1107	7.1
1023		6.6
1369
697
1600	6.3
		7.3
	27		8.5
569	5.5
619
		15
820	8.3
1016	9.5
1058		6.9
1088	7.2
365	7.7
532	7.9
752
792
1272
462
755
1683
7.8
1262
1388
1764
553
1191
1360
223
1187	8.9

2

>Sheet

1

1,

20,168

1

2,

4,245

2,079

24

2016 2

1,616

,275

2016 3

2016 4

2016 5

2016

2016 6

Mean

2016 7

Median 84,165,194

2016 8

2016 9

Standard Deviation

2016 10

Variance

2016 11

2016 2017

2016 12

Mean

2017 1

Median

71,598,111

2017 2

Rnage

2017 3

Standard Deviation

2017 4

Variance

2017 5

2017 6

2017 7

2017 8

88,677,138

2017 9

2017 10

82,229,641

2017 11

2017 12

1

2018 2

2018 3

2018 4

2018 5

2018 6

2018 7

2018 8

2018 9

2018 10

2018 11

2018 12

1

2019 2

2019 3

2019 4

2019 5

2019 6

2019 7

2019 8

2019 9

2019 10

2019 11

2019 12

1

2020 2

2020 3

Year	Month	Domestic	International	Total			Mean					8				6
													2016					5				4				7	16,4				9	68,966,					3			Median		82,229,641
51,				11	14,421,545	65,533,161	Range	55,8				12
61,593,6				10	17,382,692	78,976,302			Standard Deviation	9642546.38104557
58,894,278	16,596,730	75,491,008			Variance	91155588931975.3
62,752,723	17,868,001	80,620,724	June, July, August														2017
64,757,943	19,407,251		84,165,194	85,296,088	89,121,911
66,135,126	21,435,123	87,570,249		88,677,138
63,498,615	20,654,207	84,152,822		Rnage	3,417,427	3,842,854
58,620,581	17,161,889	75,782,470	1969490.62449059	1959655.26562437
61,709,421	16,905,446	78,614,867	2585928879970.89	2560165840059.56
59,269,837	15,653,035	74,922,872	January, February, March
59,178,833	18,014,473	77,193,306	71,158,596	73,086,734
54,109,329	17,488,782		71,598,111	68,966,324
51,078,172	14,709,988	65,788,160	13,443,141	16,085,770
63,963,808	17,910,122	81,873,930	6984558.05916325	8145550.76136723
61,099,004	18,686,523	79,785,527	32522700854548.2	44233331470673.6
64,442,977	18,865,393	83,308,370	The number of passengers in June, July and August is definitely higher than in January, February and March. The reason is judged to be an increase in passengers due to vacations and student vacations.
66,746,463	20,676,407	87,422,870	The range in June, July, and August of 2016 and 2017 is around 3000~4000, but the number of passengers in March is higher than in January and February. Thus, the range for January, February, and March is more than 10,000 different.
68,575,481	22,690,243	91,265,724
66,664,019	22,013,119
57,144,508	17,438,756	74,583,264
64,625,405	17,604,236
61,911,765	16,476,642	78,388,407
61,374,167	18,469,636	79,843,803
											2018	55,831,159	17,897,787	73,728,946
54,078,219	15,720,901	69,799,120
66,644,135	19,716,774	86,360,909
64,557,780	19,111,955	83,669,735
67,846,119	20,126,585	87,972,704
70,279,158	22,046,732	92,325,890
72,540,389	23,754,573	96,294,962
70,338,563	22,909,627	93,248,190
60,468,575	18,051,374	78,519,949
67,082,086	18,830,854	85,912,940
64,660,022	17,552,376	82,212,398
63,646,582	19,520,179	83,166,761
											2019	58,034,262	18,690,817	76,725,079
55,679,481	16,280,536	71,960,017
70,234,129	20,295,947	90,530,076
66,938,654	20,019,304	86,957,958
71,364,145	20,995,113	92,359,258
72,790,418	22,747,453	95,537,871
75,281,916	23,907,859	99,189,775
72,729,199	23,239,180	95,968,379
63,991,365	18,842,310	82,833,675
69,936,836	18,982,654	88,919,490
64,827,417	17,575,113	82,402,530
69,737,438	19,859,635	89,597,073
		2020	61,638,893	18,955,398	80,594,291
59,879,630	15,829,198	75,708,828
34,420,555	8,956,945	43,377,500