This is my assignment for this week. I am excel illiterate and am unsure how to do most of this. Any help would be appreciated.

My research project is based on a drug study. The independent variable is the drug doses, and the dependent variable is the amount of weight lost. Would I have to do three different templates for each drug dose?

Test Data

Subject	10mg dose	Subject	20mg dose	Subject	30mg dose
1	3	101	9	201	13
2	6	102	8	202	25
3	4	103	12	203	22
4	1	104	8	204	14
5	4	105	11	205	17
6	3	106	9	206	12
7	2	107	11	207	25
8	6	108	11	208	25
9	2	109	11	209	18
10	2	110	6	210	22
11	4	111	13	211	18
12	5	112	8	212	21
13	2	113	8	213	22
14	5	114	11	214	14
15	7	115	12	215	12
16	8	116	13	216	22
17	7	117	12	217	15
18	3	118	10	218	25
19	7	119	11	219	21
20	7	120	13	220	15
21	8	121	8	221	19
22	7	122	8	222	17
23	6	123	8	223	20
24	2	124	13	224	15
25	4	125	6	225	20
26	4	126	8	226	13
27	8	127	11	227	21
28	8	128	12	228	23
29	7	129	6	229	12
30	2	130	8	230	26
31	3	131	12	231	12
32	1	132	7	232	18
33	8	133	10	233	14
34	8	134	7	234	22
35	3	135	12	235	14
36	6	136	7	236	20
37	3	137	10	237	14
38	1	138	12	238	19
39	8	139	8	239	12
40	3	140	6	240	16
41	5	141	7	241	18
42	5	142	11	242	20
43	5	143	6	243	22
44	3	144	7	244	18
45	4	145	7	245	16
46	1	146	11	246	21
47	5	147	8	247	26
48	8	148	9	248	15
49	6	149	6	249	12
50	8	150	6	250	15
51	1	151	11	251	18
52	7	152	13	252	13
53	2	153	13	253	23
54	3	154	7	254	13
55	7	155	10	255	23
56	3	156	6	256	25
57	5	157	13	257	26
58	5	158	12	258	14
59	5	159	13	259	18
60	8	160	11	260	21
61	7	161	7	261	25
62	6	162	6	262	25
63	4	163	12	263	15
64	8	164	6	264	24
65	5	165	12	265	14
66	8	166	7	266	21
67	3	167	12	267	12
68	6	168	7	268	12
69	7	169	11	269	14
70	7	170	8	270	12
71	5	171	7	271	13
72	6	172	11	272	22
73	7	173	13	273	21
74	8	174	9	274	16
75	2	175	6	275	15
76	7	176	12	276	21
77	4	177	8	277	16
78	2	178	11	278	14
79	6	179	7	279	21
80	3	180	12	280	22
81	2	181	7	281	14
82	6	182	7	282	13
83	5	183	11	283	16
84	5	184	8	284	25
85	8	185	12	285	16
86	4	186	9	286	14
87	8	187	13	287	21
88	1	188	6	288	21
89	7	189	13	289	19
90	4	190	9	290	18
91	6	191	11	291	26
92	4	192	11	292	16
93	6	193	7	293	23
94	8	194	9	294	15
95	6	195	8	295	24
96	7	196	9	296	22
97	2	197	12	297	24
98	5	198	9	298	16
99	2	199	13	299	15
100	2	200	9	300	20

CreateaMicrosoftExcelspreadsheet with the two variables from your learning team's dataset.

Analyzethe data with MicrosoftExcelor other statistical tool(s), including:

• Descriptive stats for each numeric variable
• Histogram for each numeric variable
• Bar chart for each attribute (non numeric) variable
• Scatter plot if the data contains two numeric variables

Determinethe appropriate descriptive statistics.

• For normally distributed data use the mean and standard deviation.
• For significantly skewed data use the median and interquartile range.

UsetheIndividual Methodology Findings Templateto complete the descriptive statistics. UsetheDescriptive Statistics and Interpretation Exampleto develop an interpretation of the descriptive statistics.