Answered step by step
Verified Expert Solution
Question
1 Approved Answer
3. (10 points) Use the data on the posted EXCEL to answer (a) through (d). (a) Use the Description Statistics option through Data Analysis to
3. (10 points) Use the data on the posted EXCEL to answer (a) through (d). (a) Use the Description Statistics option through "Data Analysis" to find the mean, standard deviation, median, range, and standard error for Miles per gallon and engine size. Descriptive Statistics X Data Analysis X Input OK Analysis Tools Input Range: OK Cancel Anova: Single Factor Grouped By O Columns Anova: Two-Factor With Replication Cancel O Rows Help Anova: Two-Factor Without Replication Labels in first row Correlation Covariance Help Output options Descriptive Statistics O Output Range: Exponential Smoothing O New Worksheet Ply: F-Test Two-Sample for Variances Fourier Analysis New Workbook Histogram Summary statistics Confidence Level for Mears 95 OKth Largest Kth Smallest Miles per Gallon Engine Size Mean Standard Deviation Median Range Standard Error (b) Use a formula we have learned to show how to compute the standard error using the standard deviation and the count on the EXCEL output. Standard Error Miles per Gallon: Standard Error Engine Size:(c) Create a scatter plot for Miles per gallon versus engine size. Choose the Insert option on the top menu, choose charts, then choose the first Scatter plot option. File Home Insert Draw Page Layout Formulas Data Review View Get Add-ins PivotTable Recommended Table Lostrations Recommended" Maps PivotCh PivotTables My Add-ins Charts Tables Add-ins Charts Choose first option You can use formulas in EXCEL to find statistics. For example, using the supplied data set, you can find the mean for miles per gallon using =AVERAGE(A2:A399) (d) Use the formula =CORREL(A2:A399,B2:B399) to find the correlation between miles per gallon and engine size. What does your answer tell you about the association between miles per gallon and engine size? What happens, for example, to miles per gallon as engine size decreases? Correlation is
Step 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