Hello tutor, could you help in answering the following questions by using the data sets provided below. Thanks

Questions

1) Using the Analysis ToolPak in Excel, generate a table of Descriptive (Summary) Statistics for "Weekly Expenses". Type R2 in the Output Range field. Resize the columns "R" and "S" by double clicking a short vertical line between the column headers

2) State the mean and standard deviation, to 2 decimals, using the context of the data

3). Give the 5-number summary for "Weekly Expenses". Correctly order and label the summary statistics in Cells U4:U8. Place the corresponding values in Cells V4:V8. . Copy and paste the 10 cells (S4:T8)

For questions 4-6: Both the Descriptive Statistics Table from #1 and the 5-number summary from #3 provide the values of the Minimum and Maximum Weekly Expenses. Determine if the Minimum and/or Maximum Weekly Expenses are outliers by using two different methods: the 5-number summary and the z-score.

4) For the 5-number summary method: use Excel and the 5-number summary (from #3) to compute the interquartile range (IQR). Then use the IQR to compute the lower and upper limits for determining outliers.

IQR= ______

Lower Limit= _____

Upper Limit = _______

5) Can either the Minimum or Maximum Weekly Expenses be considered an outlier?

6) The z-score method requires a bell-shaped data distribution, the sample mean, and the sample standard deviation (which are provided in the Descriptive Statistics Table from #1). Using Excel, compute the z-scores for the minimum and the maximum Weekly Expenses.

Label	Value (x)	z-score	If the data distribution were bell-shaped, would this be consider an outlier?
Minimum
Maximum

7) Interpret the maximum z-score in Question 5 in the context of the story

8)Develop a Boxplot for "Weekly Expenses". Change the title to: "____'s Boxplot of Weekly Expenses for Purdue Undergraduates"

9)Specify the number of outliers in Boxplot. Are they high or low outliers?

Data Sets(Table) Please copy the table below to solve the questions above

Student ID	Age	Year	School/College	High School GPA	Semester GPA	Cumulative GPA	In-State /Out of State	Country
2709	20	Junior	Other or Undecided	2.6153	2.5	2.3922	Out	China
6104	19	Sophomore	Other or Undecided	2.8893	3.1	2.6571	In	USA
4024	19	Sophomore	Engineering	2.0577	2.25	2.3347	In	USA
4005	21	Junior	Liberal Arts	2.7415	2.93	2.237	Out	Canada
4124	21	Junior	Engineering	2.2681	2.5	2.3856	In	USA
3357	17	Freshman	Liberal Arts	1.4993	3	2.0968	Out	China
6631	20	Sophomore	Health and Human Sciences	2.3886	2.75	2.2248	In	USA
7674	22	Junior	Other or Undecided	3.9056	3.5	3.9249	Out	South Korea
4267	21	Senior	Other or Undecided	3.2549	3.8	3.1347	Out	China
144	21	Junior	Krannert	3.2843	3.25	3.183	In	USA
2592	20	Junior	Other or Undecided	4	3.8	3.966	Out	Taiwan
3092	18	Freshman	Krannert	1.9884	2.45	2.2031	In	USA
2874	19	Sophomore	Other or Undecided	3.1643	2.75	2.867	In	USA
4522	18	Freshman	Health and Human Sciences	3.7855	3.25	3.7399	In	USA
3563	19	Freshman	Science	3.1287	3.25	2.9255	In	USA
4339	19	Sophomore	Science	3.1948	2.93	2.9499	In	USA
1124	21	Junior	Engineering	2.5338	3	2.487	Out	USA
8810	20	Junior	Krannert	3.6584	3.75	3.6336	In	USA
5008	20	Sophomore	Engineering	3.8041	3.9	3.8176	In	USA
6680	20	Sophomore	Liberal Arts	3.9553	3.8	3.923	In	USA
9768	22	Senior	Engineering	3.7553	3.84	3.6078	Out	USA
2141	22	Junior	Engineering	3.7518	3.26	3.1279	Out	South Korea
9253	20	Sophomore	Krannert	3.4219	3.5	3.2997	In	USA
6140	18	Freshman	Engineering	3.8664	3.65	3.4824	Out	China
8906	19	Freshman	Science	2.9643	3.15	2.8108	In	USA
551	19	Sophomore	Engineering	3.3592	3	3.2885	In	USA
8964	21	Senior	Engineering	3.9887	3.75	3.6067	Out	USA
664	18	Freshman	Other or Undecided	2.8774	2.75	2.6618	In	USA
5694	20	Sophomore	Krannert	3.5591	2.5	3.5903	Out	Brazil
5634	21	Senior	Health and Human Sciences	3.0249	3.5	2.5926	Out	USA
8819	19	Freshman	Other or Undecided	2.9987	3	2.8929	In	USA
1887	19	Freshman	Engineering	3.9031	3.65	3.7803	Out	USA
995	21	Freshman	Engineering	3.5966	3.75	3.3278	In	USA
8313	21	Senior	Science	3.4692	3.25	3.1891	In	USA
4652	19	Sophomore	Engineering	2.6697	2.68	2.6177	Out	India
8790	18	Freshman	Other or Undecided	2.7852	2.5	2.6061	Out	USA
170	21	Sophomore	Other or Undecided	3.8895	3.1	3.7743	In	USA
1400	23	Senior	Liberal Arts	3.1056	2.25	2.5052	In	USA
2027	22	Senior	Liberal Arts	3.8851	3.1	3.71	Out	India
1299	18	Freshman	Other or Undecided	4	4	3.9164	In	USA
7968	22	Senior	Engineering	2.8991	2.25	2.7608	Out	USA
1019	21	Junior	Krannert	1.9363	2.45	2.0174	Out	USA
9132	22	Senior	Health and Human Sciences	2.6514	2.8	2.2405	Out	USA
4601	19	Freshman	Other or Undecided	2.8655	3.1	2.8551	In	USA
6513	25	Senior	Engineering	3.1585	3	3.1613	In	USA
6413	20	Sophomore	Krannert	2.3891	2.1	2.3388	Out	Colombia
6963	22	Senior	Engineering	3.8752	4	3.8515	In	USA
3049	21	Senior	Engineering	3.6556	3.15	3.4165	Out	South Korea
2724	19	Freshman	Health and Human Sciences	1.8242	2.5	2.2962	Out	Brazil
5305	21	Senior	Liberal Arts	3.0842	2.5	3.0485	In	USA
5767	19	Sophomore	Health and Human Sciences	3.2596	3.9	3.3673	In	USA
9024	21	Junior	Engineering	3.1204	3	2.7764	In	USA
116	21	Junior	Other or Undecided	2.9654	3.15	2.6615	Out	Brazil
1866	22	Senior	Engineering	3.0056	3.5	2.9419	Out	India
3074	19	Freshman	Other or Undecided	2.9103	3.5	2.9739	Out	South Korea
3854	20	Sophomore	Other or Undecided	3.4422	3.5	2.8981	In	USA
2963	20	Senior	Science	3.1339	3.25	3.0911	In	USA
6655	22	Senior	Engineering	3.5511	4	3.4252	Out	India
9805	19	Sophomore	Other or Undecided	1.9979	2.83	2.1251	In	USA
231	18	Freshman	Engineering	3.8042	3	3.6135	In	USA
6864	23	Senior	Science	3.9268	3.9	3.9322	In	USA
1423	19	Sophomore	Other or Undecided	2.7859	3.1	2.8259	In	USA
488	19	Sophomore	Krannert	3.7134	3.9	3.3487	Out	China
7368	19	Freshman	Science	3.1726	3.15	2.908	Out	China
5390	19	Sophomore	Engineering	2.6958	2.75	2.5392	Out	India
9842	21	Freshman	Other or Undecided	2.4044	2.1	2.1228	In	USA
5414	21	Junior	Science	3.5997	3.5	3.6644	Out	USA
8506	19	Sophomore	Science	3.2556	2.75	3.1528	In	USA
6878	19	Sophomore	Liberal Arts	2.7601	2.5	2.3337	In	USA
6944	20	Sophomore	Health and Human Sciences	3.7532	3.65	3.7945	In	USA
6661	21	Junior	Engineering	2.1899	2	2.3166	In	USA
3675	22	Senior	Health and Human Sciences	3.1488	2.8	2.5418	In	USA
1457	19	Freshman	Engineering	3.2294	3.25	3.1673	In	USA
3703	20	Sophomore	Engineering	3.9002	2.5	3.7003	In	USA
7136	19	Freshman	Other or Undecided	3.8924	3	3.2332	In	USA
5986	20	Junior	Other or Undecided	2.1259	3	2.1401	Out	South Korea
9267	18	Freshman	Engineering	3.0022	4	2.7605	In	USA
5704	25	Senior	Other or Undecided	3.6548	3.5	3.875	In	USA
9043	19	Freshman	Science	2.0539	2.8	2.3627	In	USA
4092	21	Junior	Krannert	2.7989	2.6	2.7644	Out	Canada
9970	18	Freshman	Other or Undecided	2.1661	2.25	2.1766	Out	USA
1481	20	Freshman	Krannert	2.3942	2.8	2.3837	Out	India
3720	18	Freshman	Engineering	2.2194	2.5	2.4013	Out	Taiwan
5605	22	Senior	Engineering	2.1361	3	2.1843	In	USA
5584	21	Freshman	Science	3.5356	3.5	3.6063	In	USA
1195	20	Junior	Other or Undecided	3.5158	3.4	3.2784	Out	Colombia
8930	21	Senior	Engineering	3.8841	2.75	3.9046	Out	China
5705	19	Freshman	Other or Undecided	3.2247	3.25	2.9585	Out	India
1158	22	Senior	Other or Undecided	3.5135	2.9	2.648	In	USA
2566	18	Freshman	Science	2.5378	2.8	2.154	In	USA
2957	21	Junior	Other or Undecided	3.1874	3.75	3.052	In	USA
4986	18	Freshman	Other or Undecided	2.2576	3.1	2.817	In	USA
8634	20	Sophomore	Health and Human Sciences	3.6507	2.75	3.0048	Out	USA
7540	21	Junior	Science	2.2354	2.5	2.3164	In	USA
2058	21	Senior	Engineering	3.2481	3	2.851	In	USA
4311	19	Freshman	Other or Undecided	3.5921	3.15	3.0737	Out	India
4488	20	Sophomore	Krannert	3.4221	3.15	2.9945	In	USA
2672	21	Junior	Other or Undecided	2.0046	2.5	2.2911	In	USA
363	21	Freshman	Engineering	1.8115	2.3	2.0717	Out	India
2737	21	Junior	Engineering	2.9661	3	2.7774	In	USA
3472	20	Junior	Engineering	2.7476	2.5	2.8614	In	USA
8657	18	Freshman	Other or Undecided	3.6507	3.6	3.5226	In	USA
2968	23	Senior	Science	3.5672	2.92	3.2407	Out	India
7781	20	Sophomore	Other or Undecided	2.9536	3.1	2.7189	Out	USA
6056	20	Sophomore	Science	3.2533	3	2.6711	Out	South Korea
1938	17	Freshman	Engineering	3.8965	3.5	3.7878	Out	India
3991	21	Junior	Engineering	2.9831	3.75	2.6683	In	USA
8446	23	Senior	Health and Human Sciences	3.7723	3.3	3.4179	Out	China
1729	18	Freshman	Engineering	3.6733	4	3.8444	In	USA
5258	18	Freshman	Krannert	4	4	3.9476	In	USA
1859	19	Freshman	Other or Undecided	3.9977	3.75	3.8476	In	USA
2977	21	Senior	Other or Undecided	3.3574	2.8	2.7526	Out	Brazil
4976	18	Freshman	Other or Undecided	3.1243	2.9	2.6517	In	USA
4794	20	Sophomore	Health and Human Sciences	2.8819	3.25	2.6814	In	USA
9439	19	Sophomore	Engineering	3.9965	3.6	3.8004	In	USA
5749	18	Freshman	Other or Undecided	2.8991	2	2.2927	In	USA
5072	20	Sophomore	Liberal Arts	3.0247	3	2.8813	Out	USA
1751	19	Sophomore	Other or Undecided	3.2147	3.15	3.0803	In	USA
8905	21	Junior	Krannert	2.3733	2.5	2.1575	In	USA
3783	21	Sophomore	Other or Undecided	3.3446	3.45	3.2607	Out	Taiwan
8691	22	Junior	Engineering	2.3937	2.6	2.5778	In	USA
6075	17	Freshman	Health and Human Sciences	1.8974	2.25	2.011	Out	Canada
3693	21	Junior	Krannert	3.4203	3	2.6877	In	USA
7848	21	Sophomore	Krannert	3.3688	3.75	3.1684	Out	Colombia
5220	21	Junior	Health and Human Sciences	3.1057	3.1	2.836	In	USA
2855	20	Sophomore	Science	3.6486	3.9	3.7471	In	USA
5478	19	Freshman	Health and Human Sciences	2.9589	2.75	2.4554	In	USA
8544	22	Junior	Science	3.4235	3.25	3.5152	Out	USA
4821	19	Sophomore	Other or Undecided	2.3946	3.1	2.401	Out	Nigeria
9007	19	Sophomore	Science	3.0261	2.75	2.4655	In	USA
2237	19	Freshman	Engineering	3.0975	3.5	3.1242	Out	USA
4151	21	Junior	Other or Undecided	2.7792	2.68	2.2999	Out	India
9825	21	Junior	Science	2.2341	2.5	2.7452	In	USA
5744	18	Freshman	Health and Human Sciences	3.1255	3.1	3.0338	Out	China
9517	24	Senior	Engineering	2.0157	2.6	2.4551	Out	USA
2465	22	Senior	Engineering	3.8642	3	3.6906	In	USA
4664	19	Sophomore	Engineering	2.3478	2.25	2.0817	In	USA
1508	19	Freshman	Other or Undecided	2.9876	2.65	2.838	In	USA
6005	22	Senior	Science	2.8873	3.1	2.9126	In	USA
8005	21	Junior	Science	3.8068	3.5	3.7913	In	USA
375	17	Freshman	Science	3.4627	3.25	3.1577	Out	USA
1775	22	Senior	Science	2.0417	3	2.1752	Out	Nigeria
5319	20	Junior	Engineering	3.1753	2.75	3.2279	Out	Taiwan
4255	21	Sophomore	Krannert	3.9624	3.75	3.937	In	USA
8833	19	Sophomore	Health and Human Sciences	2.8935	2.68	2.5067	Out	Canada
9363	19	Freshman	Science	2.9463	2.68	2.6207	Out	China
9773	20	Sophomore	Health and Human Sciences	2.7781	2.45	2.5624	In	USA
9757	18	Freshman	Engineering	2.5361	2.65	2.5691	Out	South Korea
3780	18	Freshman	Science	3.4754	3.15	2.7862	In	USA
4257	20	Junior	Engineering	3.8987	3.8	3.9393	In	USA

Current Credits	On Campus /Off Campus	Number of Roommates	Time Spent Studying/Week	Time Spent Studying/Day	Weekly Expenses	Monthly Expenses
12	On	4	20	2.2	55.68	733.86
13	On	0	8	1.49	50.31	826.4
16	On	0	11	2.89	40.15	780.68
14	Off	0	13	3.75	45.78	815.13
13	Off	0	12	2.28	40.25	565.03
15	On	1	16	1.64	32.2	532.02
17	On	0	15	2	58.34	862.53
17	Off	0	11	4.09	74.08	1011.14
13	On	0	18	4.46	44.43	595.49
12	Off	2	11	2.43	58.71	746.58
13	Off	4	9	3.53	54.93	730.71
14	On	0	15	2.44	44.64	583.02
17	Off	2	19	4.77	50.47	827.12
16	On	1	8	4.4	55.49	1183.06
17	On	1	8	1.72	60.83	1055.49
15	On	0	18	4.19	84.48	772.53
14	Off	3	9	2.47	75	1307.5
12	Off	0	12	3.12	44.43	595.49
15	Off	1	10	3.23	42.08	695.57
18	Off	4	19	4.31	42.73	575.19
15	Off	0	13	2.02	45.05	584.71
18	Off	1	13	3.67	46.2	807.9
12	On	2	19	4	64.93	1266.21
17	On	1	17	2.57	51.69	1017.1
12	On	1	17	3.67	60.11	852.46
14	Off	4	15	2.86	77.18	924.16
17	Off	3	10	3.99	58.52	850.25
15	On	0	14	3.17	34.11	539.85
12	On	4	18	3.71	35.91	873.18
16	Off	1	11	4.1	15.95	470.18
14	On	1	13	2.48	39.65	562.57
12	On	1	10	3.02	69.59	685.32
17	On	2	17	3.17	18.24	876.61
17	Off	1	11	3.88	33.24	536.28
12	Off	4	20	3.54	45.37	586.02
12	On	0	17	2.74	62.58	881.61
18	Off	4	19	3.28	51	814.2
16	Off	4	13	2.69	32.67	533.95
17	Off	0	14	2.79	52.2	614.02
15	On	2	17	3.22	40.45	782.03
14	Off	2	19	3.9	25.8	505.78
12	On	4	13	3.31	17.4	873.08
16	Off	0	11	1.34	23.41	1048.32
13	On	0	9	1.84	69.03	789.93
13	Off	1	14	3.5	50.73	913.07
18	On	2	10	2.63	61.94	653.95
12	Off	4	17	4.28	42.54	978.67
13	On	1	13	3.77	28.84	544.2
13	On	1	12	3.39	45.5	586.55
12	Off	4	9	3.28	11.64	848.89
16	On	1	9	3.54	75.25	776.25
16	Off	2	10	2.51	10	444
13	Off	1	17	2.92	65	873
15	Off	0	17	3.2	24.32	787.7
18	On	0	14	3.28	55.39	1032.64
14	On	1	14	4.68	61.98	760.32
18	Off	4	14	4.29	40	564
14	Off	0	18	3	61.94	1060.15
18	Off	4	10	2.59	54.94	847.23
12	On	0	20	3.17	32.32	561.6
16	Off	3	15	4	29.47	623.77
13	On	1	17	0.64	72.11	802.86
14	Off	1	15	3.07	42.01	778.84
12	On	1	19	2.62	66.88	674.21
12	Off	0	11	4.66	52.97	722.47
18	On	1	17	4.83	57.54	858.93
18	Off	1	16	3.37	22.25	793.45
18	Off	1	18	3.2	31.09	536.8
15	Off	1	14	4.39	100	1500
14	On	0	11	3.82	76.2	712.42
14	Off	4	13	3.94	25.5	504.55
14	Off	4	8	4.84	53.68	725.46
14	On	1	13	3.21	36.02	946.37
17	On	0	10	2.75	59.92	1051.66
13	On	1	14	0.76	58.15	1238.42
15	Off	3	15	2.76	62.77	1213.63
12	On	0	8	5.42	52.47	747.23
17	On	2	8	4.4	26.01	506.64
17	On	1	13	2.72	63.48	766.62
18	Off	3	9	2.42	23.31	1010
16	On	1	12	3.52	65.55	975.31
17	On	1	13	2.02	63.85	1218.17
18	On	1	10	2.62	50.67	712.81
12	Off	0	8	3.4	18.24	576.61
15	Off	1	17	3.17	48.94	600.65
17	On	2	11	2.65	47.11	593.15
16	On	4	12	4.31	32.92	1088.26
18	On	1	14	2.67	34.57	552.11
16	Off	1	12	4.16	91.9	1050.75
14	On	1	17	2.83	57.9	743.18
13	Off	0	18	2.18	57.57	636.04
12	On	1	13	4.27	74.09	770.45
18	On	0	18	4.69	45.25	690.05
18	On	1	11	3.05	62.4	880.8
12	Off	4	16	4.02	33.55	547.62
12	On	4	9	2.69	65.52	668.63
16	On	1	11	2.56	58.3	639.03
16	Off	4	12	3.21	47.07	592.99
13	On	3	15	3.98	45.05	584.71
14	Off	1	9	3.22	52.9	616.89
16	Off	2	13	4.38	74.66	813.57
17	On	1	20	2.63	28	817.6
18	Off	2	15	3.22	50.27	606.11
14	Off	0	19	2.57	21.82	791.64
18	Off	1	10	2.42	68.78	909.51
12	On	1	16	2.43	62.44	880.98
12	Off	3	20	3.92	37.02	585.1
18	Off	1	9	2.56	47.75	814.88
12	On	1	12	1.71	30.89	526.65
13	On	1	14	2.12	39.31	561.17
16	On	1	16	3.12	60.24	701.2
17	Off	1	11	3.22	100.78	903.9
15	On	1	16	2.56	78.96	747.42
18	On	2	13	1.29	33	838.6
15	On	1	20	2.83	41.91	571.83
13	On	0	8	2.69	34.67	573.35
15	Off	1	19	4.03	55.41	1032.72
17	Off	4	10	4.3	31.39	528.7
12	Off	2	12	3.06	97.23	1500
18	Off	0	13	3.04	60	852
14	Off	1	15	1.88	63.55	660.56
12	On	1	13	2.57	71.06	1000
15	Off	2	12	3.35	58.34	745.03
13	Off	4	10	3.6	37.2	656.24
17	Off	4	10	3.86	63.34	885.03
13	On	1	13	3.02	24.14	1051.39
15	On	1	10	2.29	43.62	699.71
17	Off	4	20	2.6	35.24	544.48
16	Off	0	14	4.67	45.25	599.1
18	Off	1	19	2.43	34.25	1140.43
13	On	0	19	2.01	44.39	686.44
12	Off	4	20	4.36	45.9	629.5
12	Off	1	20	4.28	33.65	841.33
15	On	1	17	2.79	68.05	1279.01
17	Off	3	16	1.84	74.87	936.92
14	Off	4	11	2.96	20.25	386.59
14	On	4	12	2.75	48.36	1003.11
16	On	0	13	1.86	70.14	915.63
13	Off	4	12	3.93	49.9	824.55
16	Off	0	10	3.2	46.16	993.87
18	On	1	18	3.55	36.89	551.25
17	Off	4	14	2.98	72.45	1004.29
17	Off	0	12	3.22	53.38	840.21
12	Off	1	19	2.28	36.08	547.93
18	On	3	13	5.17	71.98	759.9
14	On	0	12	3.2	20	482
17	Off	3	12	2.89	66.63	747.68
17	On	0	20	3.45	30	523
15	On	3	14	3.75	39.43	561.66
12	Off	3	19	3.2	32.1	531.61