Question: Use the raw data for both age groups into this tab to perform probability calculations. These are for questions 13-14. When copying data from one

Use the raw data for both age groups into this tab to perform probability calculations. These are for questions 13-14. When copying data from one tab to another, ensure that you use the Paste Values and make sure the values are rounded to the nearest whole number (refer to Q5-12 tab). Do not manually enter rounded numbers. Next, identify your sample size listed in the mission memo, and record it for each age group. Calculating Frequency Probability Percentage: First, use the countif function in Excel to count the number of individuals with > 240 mg/dL =countif(CellRange,">240") to identify the total number in your dataset and then divide by the total number of individuals in the data set to get a percentage. = (Number of values greater than 240 mg/dL / total number of people)*100 to identify the percentage of individuals in the dataset that are greater than 240 mg/dL

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related Mathematics Questions!