Answered step by step
Verified Expert Solution
Question
1 Approved Answer
Can someone help construct a table using a data set in Excel? Question: Use the variable Annual.miles.drive to construct the confidence intervals for the estimate
Can someone help construct a table using a data set in Excel?
Question: Use the variable "Annual.miles.drive" to construct the confidence intervals for the estimate of the population mean (i.e., mean of annual miles driven), by gender, i.e. by male and female drivers, at 94% levels. Interpret your confidence intervals.
This is what the table should look like (this is an example):
Descriptives Insured.sex Statistic Std. Error Annual. miles.drive Female Mean 8504.030996 224.7913302 96% Confidence Interval Lower Bound 8039.508207 for Mean Upper Bound 8968.553785 5% Trimmed Mean 8322.222444 Median 6213.710000 Variance 10763133.3 Std. Deviation 3280.72146 Minimum 1926.2501 Maximum 18641.1300 Range 16714.8799 Interquartile Range 6213.7100 Skewness 936 167 Kurtosis .362 332 Male Mean 8902.276229 209.6417163 96% Confidence Interval Lower Bound 8469.752228 for Mean Upper Bound 9334.800231 5% Trimmed Mean 8648.555752 Median 6213.710000 Variance 12613549.3 Std. Deviation 3551.55590 Minimum 3106.8550 Maximum 18641.1300 Range 15534.2750 Interquartile Range 6213.7100 Skewness 892 144 Kurtosis .211 .287Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started