Two Sample Mean Problem. This problem focuses on a difference of means for cholesterol levels between male and female students. There are 148 females and 164 males in our sample. This example has a large sample, however if we use the Excel file we get the correct Critical t and p-values. EXCEL DESCRIPTIVE STATISTICS FOR CHOLESTEROL LEVELS OF MALES AND FEMALES Cholesterol Mean Standard Error Median Mode Standard Deviation Sample Variance Kurtosis Skewness Range Minimum Maximum Sum Count Confidence Level (95.0%) Females Males 200.318 196.085 0.881 0.966 201 196 194 196 10.721 12.372 114.939 153.072 -0.493 -0.109 47 176 223 29647 148 1.742 0.015 0.086 61 166 227 32158 164 1.908 Next we want to do a confidence interval for difference of the two means. The Excel file Diff Means& Prop 2020.xlsx will be helpoful. Use Females - Males so that the difference is positive. We will not assume equal variances. The Descriptive Statistics are given above. Put a 95% Confidence Interval around the difference of the female mean - male mean. We want a 95% Confidence interval for the difference of the two means. What is the BOE for this Confidence Interval? Use 3 decimal places and use the proper rules of rounding.

Glencoe Algebra 1, Student Edition, 9780079039897, 0079039898, 2018
18th Edition
ISBN:9780079039897
Author:Carter
Publisher:Carter
Chapter10: Statistics
Section10.4: Distributions Of Data
Problem 22PFA
icon
Related questions
Question
Two Sample Mean Problem. This problem focuses on a difference of means
for cholesterol levels between male and female students. There are 148
females and 164 males in our sample. This example has a large sample,
however if we use the Excel file we get the correct Critical t and p-values.
EXCEL DESCRIPTIVE STATISTICS FOR CHOLESTEROL LEVELS OF MALES
AND FEMALES
Cholesterol
Mean
Standard Error
Median
Mode
Standard Deviation
Sample Variance
Kurtosis
Skewness
Range
Minimum
Maximum
Sum
Count
Confidence Level (95.0%)
Females Males
200.318 196.085
0.881
0.966
201
196
194
196
10.721 12.372
114.939 153.072
-0.493
0.015
-0.109
0.086
47
61
176
166
223
227
29647
32158
148
164
1.742
1.908
Next we want to do a confidence interval for difference of the two means.
The Excel file Diff Means& Prop 2020.xlsx will be helpoful. Use Females -
Males so that the difference is positive. We will not assume equal variances.
The Descriptive Statistics are given above. Put a 95% Confidence Interval
around the difference of the female mean - male mean.
We want a 95% Confidence interval for the difference of the two means.
What is the BOE for this Confidence Interval? Use 3 decimal places and use
the proper rules of rounding.
Transcribed Image Text:Two Sample Mean Problem. This problem focuses on a difference of means for cholesterol levels between male and female students. There are 148 females and 164 males in our sample. This example has a large sample, however if we use the Excel file we get the correct Critical t and p-values. EXCEL DESCRIPTIVE STATISTICS FOR CHOLESTEROL LEVELS OF MALES AND FEMALES Cholesterol Mean Standard Error Median Mode Standard Deviation Sample Variance Kurtosis Skewness Range Minimum Maximum Sum Count Confidence Level (95.0%) Females Males 200.318 196.085 0.881 0.966 201 196 194 196 10.721 12.372 114.939 153.072 -0.493 0.015 -0.109 0.086 47 61 176 166 223 227 29647 32158 148 164 1.742 1.908 Next we want to do a confidence interval for difference of the two means. The Excel file Diff Means& Prop 2020.xlsx will be helpoful. Use Females - Males so that the difference is positive. We will not assume equal variances. The Descriptive Statistics are given above. Put a 95% Confidence Interval around the difference of the female mean - male mean. We want a 95% Confidence interval for the difference of the two means. What is the BOE for this Confidence Interval? Use 3 decimal places and use the proper rules of rounding.
Expert Solution
trending now

Trending now

This is a popular solution!

steps

Step by step

Solved in 3 steps with 1 images

Blurred answer
Recommended textbooks for you
Glencoe Algebra 1, Student Edition, 9780079039897…
Glencoe Algebra 1, Student Edition, 9780079039897…
Algebra
ISBN:
9780079039897
Author:
Carter
Publisher:
McGraw Hill
Big Ideas Math A Bridge To Success Algebra 1: Stu…
Big Ideas Math A Bridge To Success Algebra 1: Stu…
Algebra
ISBN:
9781680331141
Author:
HOUGHTON MIFFLIN HARCOURT
Publisher:
Houghton Mifflin Harcourt