Scientists claim that there is a possible relationship between the severity of Covid-19 and a low level of blood vitamin D. The normal level for vitamin D is around 30ng/ml. For this reason, the vitamin D blood level has been measured for 2 countries, A and B, and recorded in a Microsoft Excel file (Vitamin D.xlsx). Enter this Excel file into the statistical package of your choice and answer all questions: (Please add the code and output to your answers.) a) Find the number of observations, mean, standard deviation of vitamin D level for the variables Country, Gender, and Sun_Exposure using the statistical package of your choice: b) Write down the statistical hypotheses for three separate analyses comparing the means of the groups in the following variables: (1) Country, (2) Gender, and (3) Sun_Exposure. Estimate the treatment effects for each of these three factors. Note: For the next questions, use a statistical software to randomly sample 30 observations for each Country, and save this subset of observations in a new dataset called "Question_1_Country". In SPSS: Data > Select Cases > Random sample of cases (you can save the random observations as a .sav or an excel file, if using SPSS). In R: you can use the following code to perform this random sampling. Learn this procedure as you may need to use it for other sections. Note: every time you run the following code, you will get a different dataset. Therefore, you will get different outputs (because of the random nature of random sampling). ###30 Random observations for Country A ### Country A

MATLAB: An Introduction with Applications
6th Edition
ISBN:9781119256830
Author:Amos Gilat
Publisher:Amos Gilat
Chapter1: Starting With Matlab
Section: Chapter Questions
Problem 1P
icon
Related questions
Question
use spss
Scientists claim that there is a possible relationship between the severity of Covid-19 and a
low level of blood vitamin D. The normal level for vitamin D is around 30ng/ml. For this reason,
the vitamin D blood level has been measured for 2 countries, A and B, and recorded in a
Microsoft Excel file (Vitamin_D.xlsx). Enter this Excel file into the statistical package of your
choice and answer all questions: (Please add the code and output to your answers.)
a) Find the number of observations, mean, standard deviation of vitamin D level for
the variables Country, Gender, and Sun_Exposure using the statistical package of your
choice:
b) Write down the statistical hypotheses for three separate analyses comparing
the means of the groups in the following variables: (1) Country,
(2) Gender, and (3) Sun_Exposure.
Estimate the treatment effects for each of these three factors.
Note: For the next questions, use a statistical software to randomly sample 30
observations for each Country, and save this subset of observations in a new dataset
called "Question_1_Country".
In SPSS: Data > Select Cases > Random sample of cases (you can save the random
observations as a .sav or an excel file, if using SPSS).
In R: you can use the following code to perform this random sampling. Learn this
procedure as you may need to use it for other sections.
Note: every time you run the following code, you will get a different dataset.
Therefore, you will get different outputs (because of the random nature of random
sampling).
###30 Random observations for Country A ###
Country A<- subset (Vitamin D, subset
C.A - Country A[sample(nrow(Country_A), 30).]
Country="A")
###30 Random observations for Country B ###
Country B <- subset (vitamin D, subset - Country-"B")
C.B - Country B [sample(nrow(Country B), 30),]
"8")
###Combining them in a new dataset ###
Question 1 Country <- rbind (C.A, C.B)
View(Question_1_Country)
Transcribed Image Text:use spss Scientists claim that there is a possible relationship between the severity of Covid-19 and a low level of blood vitamin D. The normal level for vitamin D is around 30ng/ml. For this reason, the vitamin D blood level has been measured for 2 countries, A and B, and recorded in a Microsoft Excel file (Vitamin_D.xlsx). Enter this Excel file into the statistical package of your choice and answer all questions: (Please add the code and output to your answers.) a) Find the number of observations, mean, standard deviation of vitamin D level for the variables Country, Gender, and Sun_Exposure using the statistical package of your choice: b) Write down the statistical hypotheses for three separate analyses comparing the means of the groups in the following variables: (1) Country, (2) Gender, and (3) Sun_Exposure. Estimate the treatment effects for each of these three factors. Note: For the next questions, use a statistical software to randomly sample 30 observations for each Country, and save this subset of observations in a new dataset called "Question_1_Country". In SPSS: Data > Select Cases > Random sample of cases (you can save the random observations as a .sav or an excel file, if using SPSS). In R: you can use the following code to perform this random sampling. Learn this procedure as you may need to use it for other sections. Note: every time you run the following code, you will get a different dataset. Therefore, you will get different outputs (because of the random nature of random sampling). ###30 Random observations for Country A ### Country A<- subset (Vitamin D, subset C.A - Country A[sample(nrow(Country_A), 30).] Country="A") ###30 Random observations for Country B ### Country B <- subset (vitamin D, subset - Country-"B") C.B - Country B [sample(nrow(Country B), 30),] "8") ###Combining them in a new dataset ### Question 1 Country <- rbind (C.A, C.B) View(Question_1_Country)
Country
A
A
A
A
A
A
A
A
A
A
A
A
A
A
A
A
A
A
A
A
A
A
A
A
A
A
A
A
A
A
A
A
A
A
A
A
A
A
A
A
A
A
A
A
A
B
B
B
B
B
B
B
B
B
B
B
B
B
B
B
B
B
B
B
B
B
B
B
B
B
B
B
B
B
B
B
B
B
B
B
B
B
B
B
B
B
B
B
B
B
Gender
Male
Male
Male
Male
Male
Female
Female
Female
Female
Female
Other
Other
Other
Other
Other
Male
Male
Male
Male
Male
Female
Female
Female
Female
Female
Other
Other
Other
Other
Other
Male
Male
Male
Male
Male
Female
Female
Female
Female
Female
Other
Other
Other
Other
Other
Male
Male
Male
Male
Male
Female
Female
Female
Female
Female
Other
Other
Other
Other
Other
Male
Male
Male
Male
Male
Female
Female
Female
Female
Female
Other
Other
Other
Other
Other
Male
Male
Male
Male
Male
Female
Female
Female
Female
Female
Other
Other
Other
Other
Other
Sun_Exposure
Low
Low
Low
Low
Low
Low
Low
Low
Low
Low
Low
Low
Low
Low
Low
Moderate
Moderate
Moderate
Moderate
Moderate
Moderate
Moderate
Moderate
Moderate
Moderate
Moderate
Moderate
Moderate
Moderate
Moderate
High
High
High
High
High
High
High
High
High
******
High
High
High
High
High
Low
Low
Low
Low
Low
Low
Low
Low
Low
Low
Low
Low
Low
Low
Low
Moderate
Moderate
Moderate
Moderate
Moderate
Moderate
Moderate
Moderate
Moderate
Moderate
Moderate
Moderate
Moderate
Moderate
Moderate
High
High
**************
High
High
High
High
High
Hight
High
High
Hight
High
High
High
High
Age
37
31
33
38
37
36
32
36
32
37
39
33
32
38
37
34
22
38
38
38
33
37
39
38
38
37
21
38
39
30
38
39
23
37
35
34
37
30
37
39
36
37
37
38
29
52
47
46
45
47
47
46
41
42
47
51
47
49
35
51
49
47
46
41
47
49
43
48
47
49
45
49
49
40
47
45
49
45
47
47
41
44
51
34
47
49
46
47
46
45
Vitamin_D_Level
45
40
39
42
38
38
39
37
44
38
43
36
41
44
34
48
57
38
45
37
60
40
42
42
44
39
38
39
45
47
55
59
46
55
51
49
51
62
55
53
53
66
53
51
57
53
3 7 7 7 51 49 35 45 48 18 46 1 45 45 8 8 55 24888222555252刃2602433321句5
47
57
47
55
51
48
51
58
48
57
67
75
Transcribed Image Text:Country A A A A A A A A A A A A A A A A A A A A A A A A A A A A A A A A A A A A A A A A A A A A A B B B B B B B B B B B B B B B B B B B B B B B B B B B B B B B B B B B B B B B B B B B B B Gender Male Male Male Male Male Female Female Female Female Female Other Other Other Other Other Male Male Male Male Male Female Female Female Female Female Other Other Other Other Other Male Male Male Male Male Female Female Female Female Female Other Other Other Other Other Male Male Male Male Male Female Female Female Female Female Other Other Other Other Other Male Male Male Male Male Female Female Female Female Female Other Other Other Other Other Male Male Male Male Male Female Female Female Female Female Other Other Other Other Other Sun_Exposure Low Low Low Low Low Low Low Low Low Low Low Low Low Low Low Moderate Moderate Moderate Moderate Moderate Moderate Moderate Moderate Moderate Moderate Moderate Moderate Moderate Moderate Moderate High High High High High High High High High ****** High High High High High Low Low Low Low Low Low Low Low Low Low Low Low Low Low Low Moderate Moderate Moderate Moderate Moderate Moderate Moderate Moderate Moderate Moderate Moderate Moderate Moderate Moderate Moderate High High ************** High High High High High Hight High High Hight High High High High Age 37 31 33 38 37 36 32 36 32 37 39 33 32 38 37 34 22 38 38 38 33 37 39 38 38 37 21 38 39 30 38 39 23 37 35 34 37 30 37 39 36 37 37 38 29 52 47 46 45 47 47 46 41 42 47 51 47 49 35 51 49 47 46 41 47 49 43 48 47 49 45 49 49 40 47 45 49 45 47 47 41 44 51 34 47 49 46 47 46 45 Vitamin_D_Level 45 40 39 42 38 38 39 37 44 38 43 36 41 44 34 48 57 38 45 37 60 40 42 42 44 39 38 39 45 47 55 59 46 55 51 49 51 62 55 53 53 66 53 51 57 53 3 7 7 7 51 49 35 45 48 18 46 1 45 45 8 8 55 24888222555252刃2602433321句5 47 57 47 55 51 48 51 58 48 57 67 75
Expert Solution
steps

Step by step

Solved in 3 steps with 2 images

Blurred answer
Follow-up Questions
Read through expert solutions to related follow-up questions below.
Follow-up Question
d) To investigate the difference in vitamin D level between countries, write down the
general assumptions of the appropriate statistical test, and check them using graphs
and/or outputs from your statistical package of choice. Note: use the
dataset for this question.
"Question_1_Country"
For normality, minimum two graphs
For testing the homogeneity of variances, use Levene's test.
Note: If using R, for Levene's test, install the R package "car".
Does the response variable need any transformation? Why?
Transcribed Image Text:d) To investigate the difference in vitamin D level between countries, write down the general assumptions of the appropriate statistical test, and check them using graphs and/or outputs from your statistical package of choice. Note: use the dataset for this question. "Question_1_Country" For normality, minimum two graphs For testing the homogeneity of variances, use Levene's test. Note: If using R, for Levene's test, install the R package "car". Does the response variable need any transformation? Why?
Solution
Bartleby Expert
SEE SOLUTION
Follow-up Question
c) Read the above code carefully and explain what each line is doing
d) To investigate the difference in vitamin D level between countries, write down the
general assumptions of the appropriate statistical test, and check them using graphs
and/or outputs from your statistical package of choice. Note: use the
"Question_1_Country" dataset for this question.
For normality, minimum two graphs
For testing the homogeneity of variances, use Levene's test.
Note: If using R, for Levene's test, install the R package "car".
Does the response variable need any transformation? Why?
e) Compare vitamin D levels for country A and country B at a significance level of 5% using a
t-test, one-way ANOVA, and regression. Compare the results of all three techniques.
For one-way ANOVA use t-test (LSD.test). Plot t-test and regression.
Note: use the "Question_1_Country" dataset for this question.
If you are using R, for the LSD.test function, install the package "agricolae".
Transcribed Image Text:c) Read the above code carefully and explain what each line is doing d) To investigate the difference in vitamin D level between countries, write down the general assumptions of the appropriate statistical test, and check them using graphs and/or outputs from your statistical package of choice. Note: use the "Question_1_Country" dataset for this question. For normality, minimum two graphs For testing the homogeneity of variances, use Levene's test. Note: If using R, for Levene's test, install the R package "car". Does the response variable need any transformation? Why? e) Compare vitamin D levels for country A and country B at a significance level of 5% using a t-test, one-way ANOVA, and regression. Compare the results of all three techniques. For one-way ANOVA use t-test (LSD.test). Plot t-test and regression. Note: use the "Question_1_Country" dataset for this question. If you are using R, for the LSD.test function, install the package "agricolae".
Solution
Bartleby Expert
SEE SOLUTION
Similar questions
Recommended textbooks for you
MATLAB: An Introduction with Applications
MATLAB: An Introduction with Applications
Statistics
ISBN:
9781119256830
Author:
Amos Gilat
Publisher:
John Wiley & Sons Inc
Probability and Statistics for Engineering and th…
Probability and Statistics for Engineering and th…
Statistics
ISBN:
9781305251809
Author:
Jay L. Devore
Publisher:
Cengage Learning
Statistics for The Behavioral Sciences (MindTap C…
Statistics for The Behavioral Sciences (MindTap C…
Statistics
ISBN:
9781305504912
Author:
Frederick J Gravetter, Larry B. Wallnau
Publisher:
Cengage Learning
Elementary Statistics: Picturing the World (7th E…
Elementary Statistics: Picturing the World (7th E…
Statistics
ISBN:
9780134683416
Author:
Ron Larson, Betsy Farber
Publisher:
PEARSON
The Basic Practice of Statistics
The Basic Practice of Statistics
Statistics
ISBN:
9781319042578
Author:
David S. Moore, William I. Notz, Michael A. Fligner
Publisher:
W. H. Freeman
Introduction to the Practice of Statistics
Introduction to the Practice of Statistics
Statistics
ISBN:
9781319013387
Author:
David S. Moore, George P. McCabe, Bruce A. Craig
Publisher:
W. H. Freeman