Question: W2: Frequency distributions and graphs; Data description V Using the data set that you identified in week 1, use Excel to find the following descriptive

W2: Frequency distributions and graphs; Data description V Using the data set that you identified in week 1, use Excel to find the following descriptive statistics for the price data. Descriptive statistics: Mean Median Standard Deviation Use these summary statistics to make two conclusions or observations about the typical vehicle in the sample. One conclusion must relate to the measure of center (mean/median) and one to the variability (standard deviation) of the vehicles. Next, add an 11th vehicle to the data set. Choose a "supercar" that costs at least $1 million. Recalculate the summary statistics to include this vehicle. Descriptive statistics: Mean Median Standard DeviationA B C D E F G H Vehicle type/class Year Make Model Price MPG city MPG highway- Color Y qualitative quantitative qualitative qualitative quantitative quantitative quantitative qualitative SUV 2022 GMC Terrain SLT $33,970 25 28 Medium ash gray SUV 2022 Mitsubishi Outlander Spo $26,990 24 30 Black SUV 2022 Chevrolet Equinox LT $28,512 26 31 Cherry Red Tintcoat SUV 2022 Chevrolet Blazer $33,595 22 29 Nitro Yellow Metallic SUV 2022 GMC Acadia SLT $41,567 19 27 Cayenne Red Tintcoat SUV 2022 Honda CRV $26,875 28 34 Platinum White Pearl SUV 2022 Hyundai Tucson $26,175 26 33 Phantom black o Truck 2022 Ford F150 XL $43,735 19 24 Animatter Blue Truck 2022 Chevrolet Silverado 1500 $40,890 19 22 Mosaic Blue Metallic Jeep 2022 Jeep Renegade Lati $28,966 23 29 Bikini Metallic WA B C D E F G H Vehicle type/class Year Make Model Price - MPG city MPG highway Color 2 qualitative quantitative qualitative qualitative quantitative quantitative quantitative qualitative 3 SUV 2022 GMC Terrain SLT $33,970 25 28 Medium ash gray SUV 2022 Mitsubishi Outlander Spo $26,990 24 30 Black 5 SUV 2022 Chevrolet Equinox LT $28,512 26 31 Cherry Red Tintcoat 6 SUV 2022 Chevrolet Blazer $33,595 22 29 Nitro Yellow Metallic 7 SUV 2022 GMC Acadia SLT $41,567 19 27 Cayenne Red Tintcoat 8 SUV 2022 Honda CRV $26,875 28 34 Platinum White Pearl SUV 2022 Hyundai Tucson $26,175 26 33 Phantom black Truck 2022 Ford F150 XL $43,735 19 24 Animatter Blue 11 Truck 2022 Chevrolet Silverado 1500 $40,890 19 22 Mosaic Blue Metallic Jeep 2022 Jeep Renegade Lati $28,966 23 29 Bikini Metallic 13 Supercar 2021 Ferrari SF90 Stradale $1,050,000 16 20 Rosso Dino

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer

Step: 1 Unlock blur-text-image

Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock

Step: 3 Unlock

Students Have Also Explored These Related Mathematics Questions!

1 MATH 309 - Statistics Portfolio Project Directions and Rubric This Assessment is worth 28% of your overall grade Outcomes Completing this Assessment will help you to: Course Outcomes 1.Organize...

MATH 131 Lab 2 8/16 The goal of this lab is to organize your data from Lab 1 into frequency distributions and graphs. Graphs should be made by hand, using a ruler. Part 1: V1, Qualitative Data (3...

can you please help solve this assignment. I will pay you for each question. its for for stat class name mir calories protein fat sodium fiber carbo sugars potass vitamins shelf weight cups C 16 95 1...

Chapter 5 Probability Distributions and Data Modeling 173 Empirical probability distribution Event Expected value Experiment Exponential distribution Goodness of fit Independent events Intersection...

For the exclusive use of C. Burgess, 2016. W13377 A-CAT CORP.: FORECASTING Jitendra Sharma wrote this case solely to provide material for class discussion. The author does not intend to illustrate...

Directions: Please complete the following statistical analyses for a quantitative data set that you collect. How you choose to collect the data is up to you. If you would prefer to find the data set...

In the attached article: What concerns are related to the article in reference to validity and reliability faced ? Were steps taken to ensure validity and reliability? Culturally Competent...

A correlation study is a type of research method in which a researcher measures two variables to understand and assess the statistical relationship between them. If a linear relationship exists, then...

In the attached article please Briefly describe the methodology used. Was the methodology appropriate? Why or why not? Could the author answer the question with the selected method? How did you make...

Professor Foley conducted a cola taste test. Each participant in the experiment first tasted 2 ounces of Coca-Cola, then 2 ounces of Pepsi, and finally 2 ounces of Sam's Choice Cola. The cola was...

In addition to the policy limits and a legal defense, the PAP provides for certain supplementary payments. Briefly describe the supplementary payments that can be paid under the liability section of...

From the following figures ascertain the break-even sales. Sales 2,000,000, Fixed Costs 500,000, Variable costs 1,200,000 and Price per unit $200. Calculate the profit and do a CVP Analysis.

A partnership must report tax basis capital accounts on the partners' Schedules K 1 and on the partnership's Schedule M 2 . True False

Consider the following information: State Probability Stock A Stock B Stock C Boom 0.65 0.09 0.04 0.03 Bust 0.35 -0.15 0.22 -0.03 What is the expected return on an equally weighted portfolio of these...

Since the test for implementing a policy is only applicable to unionized work environments, do you think personal appearance ought to be a prohibited ground in human rights legislation? Why or why...

Your best friend has recently been appointed a shop steward of their work unit. You know the friends manager and feel the manager has always been fair in dealing with staff. What advice might you...

Sam Wong has decided to file a grievance with the shop steward, alleging that he was not promoted and a more junior (in seniority) employee was. Describe the steps in the grievance process and what...