Calculate confidence intervals for the quantitative variable

Assignment Help Applied Statistics

Reference no: EM132484070

Unit 5 - Calculating Confidence Intervals

Instructions

In this assignment, you will calculate confidence intervals for the quantitative variables in the Heart Rate Dataset.

Steps

Part 1. Open the Heart Rate Dataset in Excel and identify the quantitative variables

Part 2. Make sure the data is sorted by category (e.g.male-at-rest, female at-rest, etc.)

Part 3. Use the Data Analysis tools of Excel to construct 95% and 99% confidence intervals for all 8 categories of the sorted quantitative variables. Excel will calculate the margin of error given as the "confidence interval" in the output. Use this margin of error to create your 8 confidence intervals by both adding and subtracting it from the sample mean (calculated in unit 3). This creates a range of values that is the confidence interval.

Part 4. Create a Word document, and use your calculated results to explain what the confidence intervals tell us.

Part 5. Compare the 99% and 95% intervals and explain why one is larger than the other even though we use the same sample mean value.

APA style.

Attachment:- Calculating Confidence Intervals.rar

Reference no: EM132484070

Questions Cloud

What happened to net working capital during the year : Its depreciation expenses were $0.3 million, and its total cash flow was $3.3 million. What happened to net working capital during the year?

How well do you think you know the facts : State your position on one of these issues - are you for, against, or neutral? Explain why. Avoid vagueness or ambiguity in your response. Make your position.

What would you get if you grew perpetuity : What would you get if you grew this perpetuity by the nominal growth rate, and then discounted it at the real (not nominal) cost of capital?

Determine what equivalent annual saving from purchase : What is the equivalent annual saving from the purchase if Gluon can depreciate 100% of the investment immediately. (Do not round intermediate calculations)

Calculate confidence intervals for the quantitative variable : Calculate confidence intervals for the quantitative variables in the Heart Rate Dataset - Open the Heart Rate Dataset in Excel and identify the quantitative

What did the video teach you about suicide : Please watch the video below and answer the following questions: Did this video change your opinion on suicide? What did the video teach you about suicide?

Compute the amount of revenue and gross profit or loss : Compute the amount of revenue and gross profit or loss to be recognized in 2018, 2019, and 2020 using the percentage of completion method?

Find the latest 10-k filing of verizon : Find the latest 10-K filing of Verizon, the large telecommunications company. Determine whether they use interest rate and currency swaps and why.

Cost of equity raised by selling new common stock : Trahan Lumber Company hired you to help estimate its cost of capital. You obtained the following data: D1 = $1.25; P0 = $22.50; g = 5.00% (constant); and F = 6.

User Account

All Pages