Answered step by step
Verified Expert Solution
Link Copied!

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):

image text in transcribed
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 .287

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access with AI-Powered Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Selling Today Partnering To Create Value

Authors: Gerald L. Manning

7th Canadian Edition

0133156850, 978-0133156850

Students also viewed these Mathematics questions