Calculus and Above

Calculus Questions? Ask a Mathematician for Answers ASAP

Connect one-on-one with {0} who will answer your question

2.5 Practice Problems 1. Use Excel...

2.5 Practice Problems

1. Use Excel to create a worksheet, called Data, with the following data. The data were presented in Table 4.3 and were measured in a subsample of n=10 participants who attended the seventh examination of the Framingham Offspring Study. Place the variable names in the first row of the worksheet. (Try the copy and paste icons on the menu bar to enter the data.)

Participant

ID Systolic Diastolic Total Serum Cholesterol

Blood Pressure Blood Pressure

Weight Height

1 141 76 199 138 63.00

2 119 64 150 183 69.75

3 122 62 227 153 65.75

4 127 81 227 178 70.00

5 125 70 163 161 70.50

6 123 72 210 206 70.00

7 105 81 205 235 72.00

8 113 63 275 151 60.75

9 106 67 208 213 69.00

10 131 77 159 142 61.00

2. Compute two new variables for each participant, body mass index (BMI) and mean arterial pressure (MAP). The formulas for the variables are shown below.

BMI = and

MAP ={(2*Diastolic Blood Pressure) + Systolic Blood Pressure}/3.

3. Compute the sample size for the MAP data using the COUNT function and store the result in the Data worksheet.

4. Compute the mean MAP by programming the formula for the mean (i.e., ) and store the result in the Data worksheet.

5. Compute the standard deviation of the MAP values by programming the formula for the standard deviation (i.e., ) and store the result in the Data worksheet.

1. The following data were measured in n=15 college seniors in a cross-sectional study of alcohol consumption. Each participant was asked their sex, year in school, the age at which they first consumed alcohol and the number of alcoholic drinks they consume on a typical drinking night. The data are shown below.

ID Number Sex Year in School Age at First Drink* Number of Drinks/Nig ht

1 M Freshman 14 5

2 M Senior 11 8

3 F Junior 17 3

4 M Junior 13 9

5 F Freshman 0

6 F Sophomore 15 4

7 F Freshman 15 0

8 F Freshman 0

9 M Senior 15 7

10 F Junior 21 5

11 M Junior 18 3

12 M Senior 14 6

13 F Junior 19 3

14 F Sophomore 18 2

15 M Junior 20 4

*Students who never had a drink were excluded.

Generate frequency distribution tables for sex and year in school using the Data –

Pivot Table and Pivot Chart Report option on the menu bar.

2. Generate a frequency bar chart for sex using the Pivot Table and Pivot Chart Report from problem #1.

3. Generate a frequency histogram for year in school using the Pivot Table and Pivot Chart Report from problem #1.

4. Create a frequency distribution table for drinking status, defined by the following numbers of drinks per night:

Abstinent 0

Light 1-3

Moderate 4-5

Heavy 6 or more drinks per night

5. Generate a frequency histogram for drinking status using the Chart Wizard.

6. Generate a scatter diagram to display the association between age at first drink and number of drinks per night. (Note that the sample size for analysis is n=13.)

4.3 Practice Problems

1. A study is conducted to estimate the mean total cholesterol level in children 2-6 years of age. A sample of 9 participants is selected and their total cholesterol levels are measured as follows.

185 225 240 196 175 180 194 147 223

a. Use the Data Analysis Tool to compute the sample mean, standard deviation and median.

b. Use the QUARTILE function to compute the first and third quartiles.

2. The following data were collected as part of a study of coffee consumption among graduate students. The following reflect cups per day consumed:

3 4 6 8 2 1 0 2

a. Use the Data Analysis Tool to compute the sample mean, standard deviation and median.

b. Use the QUARTILE function to compute the first and third quartiles.

3. In the study of a new anti-hypertensive medication, systolic blood pressures are measured at baseline (or the start of the study before any treatment is administered). The data are as follows:

120 112 138 145 135 150 145 163

148 128 143 156 160 142 150

Use Excel functions to compute the sample mean, standard deviation, median and quartiles.

4. The following are baby height measurements, in cm, for a sample of women participating in a study of pregnancy outcomes:

28 30 41 48 29 48 62 49 51 39

Use the Data Analysis Tool to compute summary statistics.

1. Use Excel to create a worksheet, called Data, with the following data. The data were presented in Table 4.3 and were measured in a subsample of n=10 participants who attended the seventh examination of the Framingham Offspring Study. Place the variable names in the first row of the worksheet. (Try the copy and paste icons on the menu bar to enter the data.)

Participant

ID Systolic Diastolic Total Serum Cholesterol

Blood Pressure Blood Pressure

Weight Height

1 141 76 199 138 63.00

2 119 64 150 183 69.75

3 122 62 227 153 65.75

4 127 81 227 178 70.00

5 125 70 163 161 70.50

6 123 72 210 206 70.00

7 105 81 205 235 72.00

8 113 63 275 151 60.75

9 106 67 208 213 69.00

10 131 77 159 142 61.00

2. Compute two new variables for each participant, body mass index (BMI) and mean arterial pressure (MAP). The formulas for the variables are shown below.

BMI = and

MAP ={(2*Diastolic Blood Pressure) + Systolic Blood Pressure}/3.

3. Compute the sample size for the MAP data using the COUNT function and store the result in the Data worksheet.

4. Compute the mean MAP by programming the formula for the mean (i.e., ) and store the result in the Data worksheet.

5. Compute the standard deviation of the MAP values by programming the formula for the standard deviation (i.e., ) and store the result in the Data worksheet.

1. The following data were measured in n=15 college seniors in a cross-sectional study of alcohol consumption. Each participant was asked their sex, year in school, the age at which they first consumed alcohol and the number of alcoholic drinks they consume on a typical drinking night. The data are shown below.

ID Number Sex Year in School Age at First Drink* Number of Drinks/Nig ht

1 M Freshman 14 5

2 M Senior 11 8

3 F Junior 17 3

4 M Junior 13 9

5 F Freshman 0

6 F Sophomore 15 4

7 F Freshman 15 0

8 F Freshman 0

9 M Senior 15 7

10 F Junior 21 5

11 M Junior 18 3

12 M Senior 14 6

13 F Junior 19 3

14 F Sophomore 18 2

15 M Junior 20 4

*Students who never had a drink were excluded.

Generate frequency distribution tables for sex and year in school using the Data –

Pivot Table and Pivot Chart Report option on the menu bar.

2. Generate a frequency bar chart for sex using the Pivot Table and Pivot Chart Report from problem #1.

3. Generate a frequency histogram for year in school using the Pivot Table and Pivot Chart Report from problem #1.

4. Create a frequency distribution table for drinking status, defined by the following numbers of drinks per night:

Abstinent 0

Light 1-3

Moderate 4-5

Heavy 6 or more drinks per night

5. Generate a frequency histogram for drinking status using the Chart Wizard.

6. Generate a scatter diagram to display the association between age at first drink and number of drinks per night. (Note that the sample size for analysis is n=13.)

4.3 Practice Problems

1. A study is conducted to estimate the mean total cholesterol level in children 2-6 years of age. A sample of 9 participants is selected and their total cholesterol levels are measured as follows.

185 225 240 196 175 180 194 147 223

a. Use the Data Analysis Tool to compute the sample mean, standard deviation and median.

b. Use the QUARTILE function to compute the first and third quartiles.

2. The following data were collected as part of a study of coffee consumption among graduate students. The following reflect cups per day consumed:

3 4 6 8 2 1 0 2

a. Use the Data Analysis Tool to compute the sample mean, standard deviation and median.

b. Use the QUARTILE function to compute the first and third quartiles.

3. In the study of a new anti-hypertensive medication, systolic blood pressures are measured at baseline (or the start of the study before any treatment is administered). The data are as follows:

120 112 138 145 135 150 145 163

148 128 143 156 160 142 150

Use Excel functions to compute the sample mean, standard deviation, median and quartiles.

4. The following are baby height measurements, in cm, for a sample of women participating in a study of pregnancy outcomes:

28 30 41 48 29 48 62 49 51 39

Use the Data Analysis Tool to compute summary statistics.

Show More

Show Less

Was this answer helpful?

Describe your issueThe assistant will guide you

Chat 1:1 with a tutorLicensed Experts are available 24/7

100% satisfaction guaranteeGet all the answers you need

Related Calculus and Above Questions

A pharmaceutical company claims that its new drug reduces

A pharmaceutical company claims that its new drug reduces systolic blood pressure. The systolic blood pressure (in millimeters of mercury) for nine patients before taking the new drug and 2 hours afte… read more

1. A study is run to estimate the mean total of cholesterol

1. A study is run to estimate the mean total of cholesterol level in children 2 to 6 years of age. A sample of 9 participants is selected and their total cholesterol levels are measured as follows. 18… read more

1. The following data were measured in n=15 college seniors

1. The following data were measured in n=15 college seniors in a cross-sectional study of alcohol consumption. Each participant was asked their sex, year in school, the age at which they first consume… read more

1. A study is run to estimate the mean total cholesterol level

1. A study is run to estimate the mean total cholesterol level in children 2-6 years of age. A sample of 9 participants is selected and their total cholesterol levels are measured as follows. 185 225 … read more

1. The following data were collected in a clinical trial evaluating

1. The following data were collected in a clinical trial evaluating a new compound designed to improve wound healing in trauma patients. The new compound was compared against a placebo. After treatmen… read more

4.3 Practice Problems 1. A study is conducted to estimate

4.3 Practice Problems 1. A study is conducted to estimate the mean total cholesterol level in children 2-6 years of age. A sample of 9 participants is selected and their total cholesterol levels are m… read more

Statistical Computing Using Excel. Please save your results

Statistical Computing Using Excel. Please save your results as a 97/2003 Excel file. Answers should be in the same workbook and 5.1 practice problems on Worksheet 1, 6.6 problems on Worksheet 2 and 7.… read more

Statistical Computing Using Excel. Please save your results

Statistical Computing Using Excel. Please save your results as a 97/2003 Excel file. Answers should be in the same workbook and 5.1 practice problems on Worksheet 1, 6.6 problems on Worksheet 2 and 7.… read more

Statistical Computing Using Excel. Please save your results

Statistical Computing Using Excel. Please save your results as a 97/2003 Excel file. Answers should be in the same workbook and 5.1 practice problems on Worksheet 1, 6.6 problems on Worksheet 2 and 7.… read more

For this assignment, you will be required to read Sullivans

For this assignment, you will be required to read Sullivan's (2008) Essentials of Biostatistics Workbook: Statistical Computing Using Excel. Please save your results as a 97/2003 Excel file. Answers s… read more

I. Descriptive Statistics: (20 pts) Download the dataset Final1.sav.

I. Descriptive Statistics: (20 pts) Download the dataset Final1.sav. Complete the following: 1) List the level of measurement for the variables, AGE, SEX, AGEGRP, SBP1 in the data set and describe the… read more

1. The following data were measured in n=15 college seniors

1. The following data were measured in n=15 college seniors in a cross-sectional study of alcohol consumption. Each participant was asked their sex, year in school, the age at which they first consume… read more

FOR GURU ONLY --- FOR GURU ONLY!!! Here are the first 40.

FOR GURU ONLY --- FOR GURU ONLY!!! Here are the first 40. As per your last e-mail of only getting half of what you charge, I'll pay $50 for this first 40 and $50 for the second 40 questions. If all is… read more

Hi is possible to have all work explained in an excel spreadsheet

Hi is possible to have all work explained in an excel spreadsheet with formulas so I can understand it better? Thanks Customer Question 1. Classify the following studies as descriptive or inferential … read more

Determine whether the given value is a statistic or a parameter.

Determine whether the given value is a statistic or a parameter. After taking the first exam, 15 of the students dropped the class. (Points : 6) Parameter Statistic 2. Identify the number as either co… read more

The data from your sample of 80 employees can be found on the

The data from your sample of 80 employees can be found on the tab labelled "Health Exam Results Data." The fasting total cholesterol measurement (mg/dL) is recorded as "cholesterol". Levels below 200 … read more

1. The data from your sample of 80 employees can be found

Attachment: 2012-04-09_220408_data.xls 1. The data from your sample of 80 employees can be found on the tab labelled "Health Exam Results Data." The fasting total cholesterol measurement (mg/dL) is re… read more

1. Huamn beta-endorphin (HBE) is a hormone secreted by the

1. Huamn beta-endorphin (HBE) is a hormone secreted by the pituitary gland under conditions of stress. A researcher conducted a study to investigate whether a program of regular exercise might affect … read more

Disclaimer: Information in questions, answers, and other posts on this site ("Posts") comes from individual users, not JustAnswer; JustAnswer is not responsible for Posts. Posts are for general information, are not intended to substitute for informed professional advice (medical, legal, veterinary, financial, etc.), or to establish a professional-client relationship. The site and services are provided "as is" with no warranty or representations by JustAnswer regarding the qualifications of Experts. To see what credentials have been verified by a third-party service, please click on the "Verified" symbol in some Experts' profiles. JustAnswer is not intended or designed for EMERGENCY questions which should be directed immediately by telephone or in-person to qualified professionals.

Ask-a-doc Web sites: If you've got a quick question, you can try to get an answer from sites that say they have various specialists on hand to give quick answers... Justanswer.com.

JustAnswer.com...has seen a spike since October in legal questions from readers about layoffs, unemployment and severance.

Web sites like justanswer.com/legal

...leave nothing to chance.

...leave nothing to chance.

Traffic on JustAnswer rose 14 percent...and had nearly 400,000 page views in 30 days...inquiries related to stress, high blood pressure, drinking and heart pain jumped 33 percent.

Tory Johnson, GMA Workplace Contributor, discusses work-from-home jobs, such as JustAnswer in which verified Experts answer people’s questions.

I will tell you that...the things you have to go through to be an Expert are quite rigorous.

Wonderful service, prompt, efficient, and accurate. Couldn't have asked for more. I cannot thank you enough for your help.

Freshfield, Liverpool, UK

This expert is wonderful. They truly know what they are talking about, and they actually care about you. They really helped put my nerves at ease. Thank you so much!!!!

Los Angeles, CA

Thank you for all your help. It is nice to know that this service is here for people like myself, who need answers fast and are not sure who to consult.

Hesperia, CA

I couldn't be more satisfied! This is the site I will always come to when I need a second opinion.

Kernersville, NC

Just let me say that this encounter has been entirely professional and most helpful. I liked that I could ask additional questions and get answered in a very short turn around.

Woodstock, NY

Thank you so much for taking your time and knowledge to support my concerns. Not only did you answer my questions, you even took it a step further with replying with more pertinent information I needed to know.

Elkton, Maryland

He answered my question promptly and gave me accurate, detailed information. If all of your experts are half as good, you have a great thing going here.

Dallas, TX

< Previous | Next >

rajeevanpillai

Master's Degree

1,335 satisfied customers

B.Sc Mathematics and M.Sc, M Phil Statistics

Mr. Gregory White

Master's Degree

114 satisfied customers

M.A., M.S. Education / Educational Administration

SusanAthena

Master's Degree

102 satisfied customers

Tutor for Algebra, Geometry, Statistics. Explaining math in plain English.

Dr Arthur Rubin

Doctoral Degree

96 satisfied customers

Ph.D. in Mathematics, 1978, from the California Institute of Technology, over 20 published papers

JACUSTOMER-yrynbdjl-

Master's Degree

42 satisfied customers

I have a MS in Mathematics and I have taught Mathematics for 10 years at the college level.

dhouse1940

Master's Degree

33 satisfied customers

BS mathematics, MS biostatistics, 35+ yrs designing & analyzing biological experiments.

Don

Master's Degree

29 satisfied customers

M.S. Astronautical Engineering. Math/Sci/Comp Tutor

< Previous | Next >

Disclaimer: Information in questions, answers, and other posts on this site ("Posts") comes from individual users, not JustAnswer; JustAnswer is not responsible for Posts. Posts are for general information, are not intended to substitute for informed professional advice (medical, legal, veterinary, financial, etc.), or to establish a professional-client relationship. The site and services are provided "as is" with no warranty or representations by JustAnswer regarding the qualifications of Experts. To see what credentials have been verified by a third-party service, please click on the "Verified" symbol in some Experts' profiles. JustAnswer is not intended or designed for EMERGENCY questions which should be directed immediately by telephone or in-person to qualified professionals.