Homework Help is Here – Start Your Trial Now!
Math
Statistics
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.)

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.)

Algebra & Trigonometry with Analytic Geometry
Algebra & Trigonometry with Analytic Geometry
13th Edition
ISBN:9781133382119
Author:Swokowski
Publisher:Swokowski
Chapter1: Fundamental Concepts Of Algebra
Section1.4: Fractional Expressions
Problem 38E
See similar textbooks
icon
Related questions
Question
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:
Transcribed Image Text: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:
Country Gender 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 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 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 Hight High High High High High High High 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 47 57 47 51 49 53 55 45 48 51 48 46 51 45 45 58 48 55 52 44 48 48 48 62 52 52 55 65 55 62 65 52 57 62 60 62 64 63 63 63 62 61 67 75
Transcribed Image Text:Country Gender 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 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 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 Hight High High High High High High High 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 47 57 47 51 49 53 55 45 48 51 48 46 51 45 45 58 48 55 52 44 48 48 48 62 52 52 55 65 55 62 65 52 57 62 60 62 64 63 63 63 62 61 67 75
Expert Solution
steps

Step by step

Solved in 4 steps with 3 images

SEE SOLUTIONCheck out a sample Q&A here
Blurred answer