Using the data set you created in Week 1, and using the information provided in the tutorial, calculate summary statistics as follows For each continuous variable, calculate the mean, median, mode (reporting multiple modes, where applicable), standard deviation, range, minimum, maximum, as well as the first quartile (Q1, also known as the 25th percentile) and third quartile (Q3, also known as the 75th percentile) For each categorical, ordinal or dichotomous variable, calculate out frequencies, proportions, and relative frequencies Present the data in Excel and upload to the drop box In order to receive credit for your assignment, you need to use Excel formulas as explained in the Announcements and demonstrated in the course videos https www youtube com watch v RFvFCDBev9U This is a continuation of your excel file you submitted last week So please use the same file with the data sets you imported and entered in Week 1 NOTE For this assignment, you only need to work with the Week1 Excel Practice pdf data You do not need to apply the summary statistics on the data you typed in from the workbook in Week 1 (i e , Participant ID, Systolic Blood Pressure, Diastolic Blood Pressure, Total Serum Cholesterol, Weight, and Height) Pleaseimplement the summary statistics (i e , mean, median, mode, standard deviation, range, min, max, quartile, 25th and 75th percentiles, frequencies, and relative frequencies) for all continuous variables Please calculate the frequencies, proportions, and relative frequencies for all dichotomous, categorical, and ordinal variables in the dataset When formally submitting an Excel file for a grade, please incorporate the following guidelines In assigning a grade, I do download and review your file If I click on a given cell containing a specific result, I should be able to see the Excel formula, i e in the form of '' ExcelFormula ( XYZ )'' where ExcelFormula is the Excel Formula and XYZ are the required inputs for the function For example, if I'm calculating the mean of age, then an appropriate submission would be AVERAGE(C2 C21) Where ''AVERAGE'' is the Excel function and ''C2 C21'' is the range of cells that contain the age data The above formula is seen in the formula bar near the top of your Excel window while the actual numerical result is shown in the cell within the spreadsheet Please do not submit an Excel sheet without any proper Excel formulas where intermediate steps are shown ''by hand'' or manually This assignment is meant to get you experience with Excel before moving on to larger data sets Visit this link for a recording of my instructions and guidance on your Week 2 Written Assignment AutoSave O Off) LaKenya Denise Drayton Excel O Search LaKenya Drayton LD X File Home Insert Page Layout Formulas Data Review View Help Share Comments Times New Roman 10 A A Insert ap Wrap Text General Ex AYO Delete v Paste B Merge Center $ 9 00 20 Conditional Format as Cell Sort Find Analyze Formatting Table Styles Format D Filter Select Data Clipboard S Font Alignment Number Styles Cells Editing Analysis B24 X V SUM(B2 B21) A B C H J K L man 35 24 wut moderate 6 A W man 51 31 low 10 man 52 32 none 9 au man 46 26 0 none 10 man 58 27 O none 8 man 53 31 severe 6 1 00 man 47 25 none 9 10 man 34 31 moderate 11 man 37 18 6 H H O H O O O O H H O H O O O O H O MT H H O O O H O O O O H O H O O Q severe HH OH H O O O H H H H O H O H H HOMT ANA HOW NUWAN 12 woman 29 24 OH HOO O O O O O O H O O HO none 10 13 woman 54 33 low 14 woman 60 29 moderate uwa 15 woman 49 20 low 16 woman 59 28 low 7 17 woman 57 29 severe 3 18 woman 43 18 OOH none 19 woman 21 33 2 moderate 6 20 woman 29 33 none 11 21 woman 55 20 4 none 9 22 Ethnicity (1 white, 2 black, 3 hispanic,4 asian, 5 other) 23 Dichotomous Continuous Continuous Ordinal Dichotomous Dichotomous Dichotomous Dichotomous Dichotomous Ordinal Continuous 24 N A 922 537 56 13 8 12 N A 140 Table 1 Ready 100 AutoSave O Off) LaKenya Denise Drayton Excel O Search LaKenya Drayton LD X File Home Insert Page Layout Formulas Data Review View Help Share Comments Times New Roman 10 A A Insert ap Wrap Text General Ex APO Delete v Paste B Merge Center $ 9 08 320 Conditional Format as Cell Sort Find Analyze Formatting Table Styles Format D Filter Select Data Clipboard Font Alignment Number Styles Cells Editing Analysis B24 X V SUM(B2 B21) A B C D E F G H I J K L Gender Age BMI Ethnicity Diabetes Obesity Family History DM Family History Ob Insomnia Sleep Apnea hrs sleep man 53 25 2 1 0 low 5 man 35 24 moderate 6 man 51 31 low 10 man 52 32 0 none 9 man 46 26 O none 10 man 58 27 0 none 8 00 man 53 31 severe 6 9 man 47 25 none 9 10 man 34 31 moderate 7 11 man 37 18 severe 6 OHOO OO O O O O O HOOO HOO O O H HO HO HO 12 woman 29 24 A N N A NAH HOW NUWANWUT HHOH H O O O H H H O H O O OH HO O O H O O O O H O O O HO none 10 13 woman 54 33 low wa 14 woman 60 29 moderate 15 woman 49 20 low 16 woman 59 28 low 17 woman 57 29 severe 3 18 woman 43 18 none 19 woman 21 33 moderate 20 woman 29 33 none 11 21 woman 55 20 O none 9 22 Ethnicity (1 white, 2 black, 3 hispanic,4 asian, 5 other) Table 1 Ready 100

The Answer is in the image, click to view ...

Answered step by step

Verified Expert Solution

Link Copied!

Question

1 Approved Answer

Posted on Jun 27, 2024

Using the data set you created in Week 1, and using the information provided in the tutorial, calculate summary statistics as follows: For each continuous

Using the data set you created in Week 1, and using the information provided in the tutorial, calculate summary statistics as follows:

For each continuous variable, calculate the mean, median, mode (reporting multiple modes, where applicable), standard deviation, range, minimum, maximum, as well as the first quartile (Q1, also known as the 25th percentile) and third quartile (Q3, also known as the 75th percentile).
For each categorical, ordinal or dichotomous variable, calculate out frequencies, proportions, and relative frequencies. Present the data in Excel and upload to the drop box.

In order to receive credit for your assignment, you need to use Excel formulas as explained in the Announcements and demonstrated in the course videos. https://www.youtube.com/watch?v=RFvFCDBev9U This is a continuation of your excel file you submitted last week.So please use the same file with the data sets you imported and entered in Week 1.NOTE:For this assignment, you only need to work with the Week1 Excel Practice.pdf data. You do not need to apply the summary statistics on the data you typed in from the workbook in Week 1 (i.e., Participant ID, Systolic Blood Pressure, Diastolic Blood Pressure, Total Serum Cholesterol, Weight, and Height).
Pleaseimplement the summary statistics (i.e., mean, median, mode, standard deviation, range, min, max, quartile, 25th and 75th percentiles, frequencies, and relative frequencies)forallcontinuous variables.
Please calculate the frequencies, proportions, and relative frequenciesforalldichotomous, categorical, and ordinal variables in the dataset.
When formally submitting an Excel file for a grade, please incorporate the following guidelines. In assigning a grade, I do download and review your file. If I click on a given cell containing a specific result, I should be able to see the Excel formula, i.e. in the form of ''=ExcelFormula(XYZ)'' whereExcelFormulais the Excel Formula andXYZare the required inputs for the function.
For example, if I'm calculating the mean of age, then an appropriate submission would be:
=AVERAGE(C2:C21)
Where ''AVERAGE'' is the Excel function and ''C2:C21'' is the range of cells that contain the age data. The above formula is seen in the formula bar near the top of your Excel window while the actual numerical result is shown in the cell within the spreadsheet.
Please do not submit an Excel sheet without any proper Excel formulaswhere intermediate steps are shown ''by hand'' or manually.This assignment is meant to get you experience with Excel before moving on to larger data sets.
Visit this link for a recording of my instructions and guidance on your Week 2 Written Assignment.

AutoSave O Off) LaKenya Denise Drayton - Excel O Search LaKenya Drayton LD X File Home Insert Page Layout Formulas Data Review View Help Share Comments Times New Roman ~ 10 ~ A" A Insert ap Wrap Text General Ex AYO Delete v Paste B Merge & Center $ ~ % 9 00 20 Conditional Format as Cell Sort & Find & Analyze Formatting Table Styles Format D Filter ~ Select Data Clipboard S Font Alignment Number Styles Cells Editing Analysis B24 X V =SUM(B2:B21) A B C H J K L man 35 24 wut moderate 6 A W man 51 31 low 10 man 52 32 none 9 au man 46 26 0 none 10 man 58 27 O none 8 man 53 31 severe 6 1 00 man 47 25 none 9 10 man 34 31 moderate 11 man 37 18 6 H H O H O O O O H H O H O O O O H O MT H H O O O H O O O O - H O H O - - O Q severe HH OH H O O O H H H H O H O H H HOMT ANA-HOW--NUWAN 12 woman 29 24 OH HOO O - O O O O - - O H O O HO none 10 13 woman 54 33 low 14 woman 60 29 moderate uwa 15 woman 49 20 low 16 woman 59 28 low 7 17 woman 57 29 severe 3 18 woman 43 18 OOH - - - none 19 woman 21 33 2 moderate 6 20 woman 29 33 none 11 21 woman 55 20 4 none 9 22 Ethnicity (1=white, 2=black, 3=hispanic,4=asian, 5=other) 23 Dichotomous Continuous Continuous Ordinal Dichotomous Dichotomous Dichotomous Dichotomous Dichotomous Ordinal Continuous 24 N/A 922 537 56 13 8 12 N/A 140 Table 1 + Ready + 100%AutoSave O Off) LaKenya Denise Drayton - Excel O Search LaKenya Drayton LD X File Home Insert Page Layout Formulas Data Review View Help Share Comments Times New Roman ~ 10 ~ A" A Insert ap Wrap Text General Ex APO Delete v Paste B Merge & Center $ ~ % 9 08 320 Conditional Format as Cell Sort & Find & Analyze Formatting Table Styles Format D Filter ~ Select Data Clipboard Font Alignment Number Styles Cells Editing Analysis B24 X V =SUM(B2:B21) A B C D E F G H I J K L Gender Age BMI Ethnicity Diabetes Obesity Family History DM Family History Ob Insomnia Sleep Apnea # hrs sleep man 53 25 2 1 0 low 5 man 35 24 moderate 6 man 51 31 low 10 man 52 32 0 none 9 man 46 26 O none 10 man 58 27 0 none 8 + 00 man 53 31 severe 6 9 man 47 25 none 9 10 man 34 31 moderate 7 11 man 37 18 severe 6 OHOO OO - - O - O O O O - HOOO HOO O O H HO HO - HO 12 woman 29 24 A N N A NAH HOW - - NUWANWUT HHOH H O O O H H - H O H O - - -O OH HO O O H O O O O - H O - O O HO none 10 13 woman 54 33 low wa 14 woman 60 29 moderate 15 woman 49 20 low 16 woman 59 28 low 17 woman 57 29 severe 3 18 woman 43 18 none 19 woman 21 33 moderate 20 woman 29 33 none 11 21 woman 55 20 O none 9 22 Ethnicity (1=white, 2=black, 3-hispanic,4=asian, 5=other) Table 1 + Ready + 100%