Copy and paste an image of your table with data for Patients 1 and 2 in the space provided below. This image should include the calculated values for Mean and Std Dev.Compare the values for Mean and Std Dev for the two patients. Did both patients meet the requirements for an average of 1800.0 Calories per day? Explain in your own words your interpretation of the Std Dev values for the two sets of patient data. been advised by a Nutritionist that they need to restrict their daily caloric intake toan average of 1800.0 Calories per day, for a 10-day period. Patients are asked torecord their daily caloric intake values. To determine whether the patients met theirgoals, you will use MS Excel to calculate the Mean and Standard Deviation, and thenanalyze the results.Table 03. Day vs Caloric Intake Data of Patients 1 and 2 for Exercise 03Caloric IntakeDay12345678910MeanStd DevPatient11800.01800.01800.01800.01800.01800.01800.01800.01800.01800.0Patient21800.02400.01800.01500.01300.01500.02300.02600.01000.01800.0a) Copy the data shown in the table above into Excel.b) Click here for a video tutorial on how to use Excel functions to calculatethe Mean and Standard Deviation for both sets of data.c) Once you have completed your calculations, save your Excel file andcomplete the related questions in the lab report. Exercise 03 - Calculating Mean (Average) and Standard DeviationCreate a new sheet in Excel and name it Exercise 03.An average of a set of numbers, also known as the Mean, is calculated by adding allof the values, and dividing by the number of values. For example, to calculate theaverage of the four numbers, you add the numbers, and divide by 4Average = (4.5+ 5.0 +5.5+ 5.0)/4= 5.0The Standard Deviation (SD) is a measure of how spread out the numbers arearound the average. When all of the values in the average are very close together,the SD is small. When the values vary significantly, the SD can be high. Why is thisrelevant? Imagine that you are applying for a job as a Nurse, and you are told thatthe average starting salary in the area where you want to work is $48, 000. Soundsgreat, right? However, if the average is $48, 000, then that means some peopleearn more than that, and some earn less. If the SD is $2,000, then most of thesalaries are close to $48, 000, but if the SD is $20, 000, then some salaries could beas high as $68, 000, while some could be as low as $28,000.In this exercise, you are going to use Excel to calculate the Average and SD for twosets of patient data, and then analyze the results. You have two patients who havePage 4 of 10been advised by a Nutritionist that they need to restrict their daily caloric intake toan average of 1800.0 Calories per day, for a 10-day period. Patients are asked torecord their daily caloric intake values. To determine whether the patients met theirgoals, you will use MS Excel to calculate the Mean and Standard Deviation, and thenanalyze the results.

Answered: Image /qna-images/answer/be629abf-41a0-46fc-ae86-994204352e29.jpg

Answered: been advised by a Nutritionist that…

MATLAB: An Introduction with Applications

6th Edition

ISBN:9781119256830

Author:Amos Gilat

Publisher:Amos Gilat

Chapter1: Starting With Matlab

Section: Chapter Questions

Problem 1P

See similar textbooks

Related questions

Question

Copy and paste an image of your table with data for Patients 1 and 2 in the space provided below. This image should include the calculated values for Mean and Std Dev.
Compare the values for Mean and Std Dev for the two patients. Did both patients meet the requirements for an average of 1800.0 Calories per day? Explain in your own words your interpretation of the Std Dev values for the two sets of patient data.

been advised by a Nutritionist that they need to restrict their daily caloric intake to
an average of 1800.0 Calories per day, for a 10-day period. Patients are asked to
record their daily caloric intake values. To determine whether the patients met their
goals, you will use MS Excel to calculate the Mean and Standard Deviation, and then
analyze the results.
Table 03. Day vs Caloric Intake Data of Patients 1 and 2 for Exercise 03
Caloric Intake
Day
1
2
3
4
5
6
7
8
9
10
Mean
Std Dev
Patient
1
1800.0
1800.0
1800.0
1800.0
1800.0
1800.0
1800.0
1800.0
1800.0
1800.0
Patient
2
1800.0
2400.0
1800.0
1500.0
1300.0
1500.0
2300.0
2600.0
1000.0
1800.0
a) Copy the data shown in the table above into Excel.
b) Click here for a video tutorial on how to use Excel functions to calculate
the Mean and Standard Deviation for both sets of data.
c) Once you have completed your calculations, save your Excel file and
complete the related questions in the lab report.

Exercise 03 - Calculating Mean (Average) and Standard Deviation
Create a new sheet in Excel and name it Exercise 03.
An average of a set of numbers, also known as the Mean, is calculated by adding all
of the values, and dividing by the number of values. For example, to calculate the
average of the four numbers, you add the numbers, and divide by 4
Average = (4.5+ 5.0 +5.5+ 5.0)/4= 5.0
The Standard Deviation (SD) is a measure of how spread out the numbers are
around the average. When all of the values in the average are very close together,
the SD is small. When the values vary significantly, the SD can be high. Why is this
relevant? Imagine that you are applying for a job as a Nurse, and you are told that
the average starting salary in the area where you want to work is $48, 000. Sounds
great, right? However, if the average is $48, 000, then that means some people
earn more than that, and some earn less. If the SD is $2,000, then most of the
salaries are close to $48, 000, but if the SD is $20, 000, then some salaries could be
as high as $68, 000, while some could be as low as $28,000.
In this exercise, you are going to use Excel to calculate the Average and SD for two
sets of patient data, and then analyze the results. You have two patients who have
Page 4 of 10
been advised by a Nutritionist that they need to restrict their daily caloric intake to
an average of 1800.0 Calories per day, for a 10-day period. Patients are asked to
record their daily caloric intake values. To determine whether the patients met their
goals, you will use MS Excel to calculate the Mean and Standard Deviation, and then
analyze the results.

Definition Definition Measure of central tendency that is the average of a given data set. The mean value is evaluated as the quotient of the sum of all observations by the sample size. The mean, in contrast to a median, is affected by extreme values. Very large or very small values can distract the mean from the center of the data. Arithmetic mean: The most common type of mean is the arithmetic mean. It is evaluated using the formula: μ = 1 N ∑ i = 1 N x i Other types of means are the geometric mean, logarithmic mean, and harmonic mean. Geometric mean: The nth root of the product of n observations from a data set is defined as the geometric mean of the set: G = x 1 x 2 ... x n n Logarithmic mean: The difference of the natural logarithms of the two numbers, divided by the difference between the numbers is the logarithmic mean of the two numbers. The logarithmic mean is used particularly in heat transfer and mass transfer. ln x 2 − ln x 1 x 2 − x 1 Harmonic mean: The inverse of the arithmetic mean of the inverses of all the numbers in a data set is the harmonic mean of the data. 1 1 x 1 + 1 x 2 + ...

Expert Solution