Answered step by step
Verified Expert Solution
Link Copied!

Question

00
1 Approved Answer

For this project, you will be using the StatCrunch data file Math 110 Car Models 2019 Dataset. Part 1: Data Summary (125 points) 1. There

For this project, you will be using the StatCrunch data file Math 110 Car Models 2019 Dataset.

Part 1: Data Summary (125 points) 1. There are 22 variables in the Car Models dataset, corresponding with the columns in the dataset. State whether each variable is quantitative or categorical. 2. The data in this dataset was compiled by a statistics professor who is researching purchasing a new car. The statistics professor wants to explore the variables related to cars in order to make the best purchasing decision. The statistics professor visited car dealerships in the east bay and asked questions to get this information about car models. Is the statistics professor conducting an observational study or an experiment? Explain your reasoning. 3. What types of unintentional bias and/or confounding factors might affect the data in this dataset?

Part 2: Exploratory Data Analysis (250 points) 1. Categorical data: For 4 of the categorical variables in the dataset, create a pie chart or bar graph showing the distribution of values. Include screenshots or images of the graphs. For each of these graphs, write 1-2 sentences describing the distribution of data. 2. Quantitative data: For 4 of the quantitative variables in the dataset, create a histogram, stem and leaf plot, or boxplot showing the distribution of values. Include screenshots or images of the graphs. Also include the five number summary for each quantitative variable. For each of these graphs, write 1-2 sentences describing the distribution of data. 3. The statistics professor asks the research question: Does the size of the engine in liters affect the overall MPG? Create a scatter plot to answer this research question. Include a screenshot or image of the graph. Explain if the association is positive, negative, or no association. Write at least 2-3 sentences explaining your reasoning. 4. The statistics professor asks another research question: Is there a relationship between HP (horsepower) and weight (in lbs) of a car? Create a scatter plot to answer this research question. Include a screenshot or image of the graph. Explain if the association is positive, negative, or no association. Write at least 2-3 sentences explaining your reasoning. Question 5 continues on the next page 5. Create side by side boxplots for Length (in), Width (in), Height (in). In StatCrunch, select Graph -> Boxplot. Select all 3 columns by clicking and dragging the mouse, or by holding the control key and clicking to select all 3 columns. You can choose whether to use fences to identify outliers or not, and you can choose whether to draw boxes horizontally or vertically. Include a screenshot or image of the graph. a. Which variable in the boxplot has the highest median? Lowest median? b. Which variable in the boxplot has the largest spread from min to max? Least spread from min to max?

Part 3: Probability (250 points) For this section, you will create a two-way table to analyze the relationship between the type of car and the drive wheels. To create a two-way table, select Stat -> Tables -> Contingency -> With Data. Choose the variables Type and Drive Wheels. It will not matter which variable you choose for the rows and which variable you choose for the columns. We will only use the top table in the results, not the Chi-Square test or any values below that. 1. Paste the table into the assignment below. You only need to paste the top table in the results, not the Chi-Square test or any values below that. You can highlight the table and copy-paste the table into a document, or include a screenshot. 2. Professor Julies current car is a sedan. Find the probability that a car in this dataset is a sedan. Show your calculations in your answer explanation. 3. Professor Julie is interested in a car with all wheel drive, denoted as AWD in the table. What is the probability that a car make and model is available in AWD? Include any of the drive wheel categories that have the possibility of AWD, E.g also include the categories Front, AWD, 4WD and Rear, AWD, 4WD as possibilities. Show your calculations in your answer explanation. 4. What is the probability that a car make and model is only available in Front wheel drive and is a station wagon? E.g do not include the categories Front, AWD, 4WD as possibilities. Show your calculations in your answer explanation. 5. What is the probability that a car is a hatchback or only available in Front wheel drive? Show your calculations in your answer explanation.

Part 4: Normal Approximation Models (200 points) 1. Create a histogram of the variable horsepower, coded as HP in the dataset. When you create the histogram, scroll down to Display Choices. Include an overlay of the normal distribution by choosing Overlay distrib. Normal in the pull down choices. Record the mean and standard deviation of the Normal distribution overlay here. Include a screenshot or image of the graph here. 2. Professor Julies current car has horsepower 147 HP. Using the mean and standard deviation from the Normal distribution overlay that you found in question #1, find the Z-stat (also known as the Z-score) for a car with horsepower 147 HP. Show your calculations. Type the math calculations as best as you can. You can use the * symbol or () to represent multiplication and use / symbol to represent division. 3. Find the probability that a car has less than 147 HP. Use the StatCrunch Normal Calculator and the mean and standard deviation from the Normal distribution overlay that you found in question #1 to answer this question. The Normal Calculator is found by selecting Stat -> Calculators -> Normal. Include a screenshot or image of the graph here. 4. Find the probability that a car has more than 147 HP. Use the StatCrunch Normal Calculator and the mean and standard deviation from the Normal distribution overlay that you found in question #1 to answer this question. The Normal Calculator is found by selecting Stat -> Calculators -> Normal. Include a screenshot or image of the graph here. 5. Find the probability that a car has between 150 HP and 350 HP. Use the StatCrunch Normal Calculator and the mean and standard deviation from the Normal distribution overlay that you found in question #1 to answer this question. The Normal Calculator is found by selecting Stat -> Calculators -> Normal. Include a screenshot or image of the graph here.

image text in transcribed
image text in transcribed
image text in transcribed
For this project, you will be using the StatCrunch data file Math 110 Car Models 2019 Dataset. Part 1: Data Summary (125 points) 1. There are 22 variables in the Car Models dataset, corresponding with the columns in the dataset. State whether each variable is quantitative or categorical 2. The data in this dataset was compiled by a statistics professor who is researching purchasing a new car. The statistics professor wants to explore the variables related to cars in order to make the best purchasing decision. The statistics professor visited car dealerships in the east bay and asked questions to get this information about car models. is the statistics professor conducting an observational study or an experiment? Explain your reasoning. 3. What types of unintentional bias and/or confounding factors might affect the data in this dataset? Part 2: Exploratory Data Analysis (250 points) 1. Categorical data: For 4 of the categorical variables in the dataset, create a pie chart or bar graph showing the distribution of values. Include screenshots or images of the graphs. For each of these graphs, write 1-2 sentences describing the distribution of data. 2. Quantitative data: For 4 of the quantitative variables in the dataset, create a histogram, stem and leaf plot, or boxplot showing the distribution of values. Include screenshots or images of the graphs. Also include the five number summary for each quantitative variable. For each of these graphs, write 1-2 sentences describing the distribution of data. 3. The statistics professor asks the research question: Does the size of the engine in liters affect the overall MPG? Create a scatter plot to answer this research question. Include a screenshot or image of the graph. Explain if the association is positive, negative, or no association. Write at least 2-3 sentences explaining your reasoning. 4. The statistics professor asks another research question: Is there a relationship between HP (horsepower) and weight (in lbs) of a car? Create a scatter plot to answer this research question. Include a screenshot or image of the graph. Explain if the association is positive, negative, or no association. Write at least 2-3 sentences explaining your reasoning. Question 5 continues on the next page 5. Create side by side boxplots for Length (in), Width (in), Height (in). In StatCrunch, select Graph -> Boxplot. Select all 3 columns by clicking and dragging the mouse, or by holding the control key and clicking to select all 3 columns. You can choose whether to use fences to identify outliers or not, and you can choose whether to draw boxes horizontally or vertically. Include a screenshot or image of the graph. a. Which variable in the boxplot has the highest median? Lowest median? b. Which variable in the boxplot has the largest spread from min to max? Least spread from min to max? Part 3: Probability (250 points) For this section, you will create a two-way table to analyze the relationship between the type of car and the drive wheels. To create a two-way table, select Stat -> Tables -> Contingency -> With Data. Choose the variables Type and Drive Wheels. It will not matter which variable you choose for the rows and which variable you choose for the columns. We will only use the top table in the results, not the "Chi-Square test" or any values below that. 1. Paste the table into the assignment below. You only need to paste the top table in the results, not the "Chi-Square test" or any values below that. You can highlight the table and copy-paste the table into a document, or include a screenshot 2. Professor Julie's current car is a sedan. Find the probability that a car in this dataset is a sedan. Show your calculations in your answer explanation. 3. Professor Julie is interested in a car with all wheel drive, denoted as AWD in the table. What is the probability that a car make and model is available in AWD? Include any of the drive wheel categories that have the ppssibility of AWD, E.g also include the categories Front, AWD, 4WD and Rear, AWD, 4WD as possibilities. Show your calculations in your answer explanation. 4. What is the probability that a car make and model is only available in Front wheel drive and is a station wagon? E.g do not include the categories Front, AWD, 4WD as possibilities. Show your calculations in your answer explanation. 5. What is the probability that a car is a hatchback or only available in Front wheel drive? Show your calculations in your answer explanation. Part 4: Normal Approximation Models (200 points) 1. Create a histogram of the variable horsepower, coded as HP in the dataset. When you create the histogram, scroll down to Display Choices. Include an overlay of the normal distribution by choosing Overlay distrib. Normal in the pull down choices. Record the mean and standard deviation of the Normal distribution overlay here. Include a screenshot or image of the graph here. 2. Professor Julie's current car has horsepower 147 HP. Using the mean and standard deviation from the Normal distribution overlay that you found in question #1, find the Z-stat (also known as the Z-score) for a car with horsepower 147 HP. Show your calculations. Type the math calculations as best as you can. You can use the symbol or () to represent multiplication and use / symbol to represent division 3. Find the probability that a car has less than 147 HP. Use the StatCrunch Normal Calculator and the mean and standard deviation from the Normal distribution overlay that you found in question #1 to answer this question. The Normal Calculator is found by selecting Stat -> Calculators -> Normal. Include a screenshot or image of the graph here. 4. Find the probability that a car has more than 147 HP. Use the StatCrunch Normal Calculator and the mean and standard deviation from the Normal distribution overlay that you found in question #1 to answer this question. The Normal Calculator is found by selecting Stat -> Calculators -> Normal. Include a screenshot or image of the graph here. 5. Find the probability that a car has between 150 HP and 350 HP. Use the StatCrunch Normal Calculator and the mean and standard deviation from the Normal distribution overlay that you found in question #1 to answer this question. The Normal Calculator is found by selecting Stat -> Calculators -> Normal. Include a screenshot or image of the graph here. Part 5: Making a Recommendation (25 points) Professor Donovan is considering buying a new car. Here are her preferences: Parent Company USA or Japan, Lowest MSRP cost under $35000, seats at least 5, Wagon, SUV, or Minivan, MPG above 20, Wheelbase over 100 inches. Use the graphs you made in Part 2 and scroll through the data set to find some cars that might be a match. Recommend at least two cars for Professor Julie to choose from. For this project, you will be using the StatCrunch data file Math 110 Car Models 2019 Dataset. Part 1: Data Summary (125 points) 1. There are 22 variables in the Car Models dataset, corresponding with the columns in the dataset. State whether each variable is quantitative or categorical 2. The data in this dataset was compiled by a statistics professor who is researching purchasing a new car. The statistics professor wants to explore the variables related to cars in order to make the best purchasing decision. The statistics professor visited car dealerships in the east bay and asked questions to get this information about car models. is the statistics professor conducting an observational study or an experiment? Explain your reasoning. 3. What types of unintentional bias and/or confounding factors might affect the data in this dataset? Part 2: Exploratory Data Analysis (250 points) 1. Categorical data: For 4 of the categorical variables in the dataset, create a pie chart or bar graph showing the distribution of values. Include screenshots or images of the graphs. For each of these graphs, write 1-2 sentences describing the distribution of data. 2. Quantitative data: For 4 of the quantitative variables in the dataset, create a histogram, stem and leaf plot, or boxplot showing the distribution of values. Include screenshots or images of the graphs. Also include the five number summary for each quantitative variable. For each of these graphs, write 1-2 sentences describing the distribution of data. 3. The statistics professor asks the research question: Does the size of the engine in liters affect the overall MPG? Create a scatter plot to answer this research question. Include a screenshot or image of the graph. Explain if the association is positive, negative, or no association. Write at least 2-3 sentences explaining your reasoning. 4. The statistics professor asks another research question: Is there a relationship between HP (horsepower) and weight (in lbs) of a car? Create a scatter plot to answer this research question. Include a screenshot or image of the graph. Explain if the association is positive, negative, or no association. Write at least 2-3 sentences explaining your reasoning. Question 5 continues on the next page 5. Create side by side boxplots for Length (in), Width (in), Height (in). In StatCrunch, select Graph -> Boxplot. Select all 3 columns by clicking and dragging the mouse, or by holding the control key and clicking to select all 3 columns. You can choose whether to use fences to identify outliers or not, and you can choose whether to draw boxes horizontally or vertically. Include a screenshot or image of the graph. a. Which variable in the boxplot has the highest median? Lowest median? b. Which variable in the boxplot has the largest spread from min to max? Least spread from min to max? Part 3: Probability (250 points) For this section, you will create a two-way table to analyze the relationship between the type of car and the drive wheels. To create a two-way table, select Stat -> Tables -> Contingency -> With Data. Choose the variables Type and Drive Wheels. It will not matter which variable you choose for the rows and which variable you choose for the columns. We will only use the top table in the results, not the "Chi-Square test" or any values below that. 1. Paste the table into the assignment below. You only need to paste the top table in the results, not the "Chi-Square test" or any values below that. You can highlight the table and copy-paste the table into a document, or include a screenshot 2. Professor Julie's current car is a sedan. Find the probability that a car in this dataset is a sedan. Show your calculations in your answer explanation. 3. Professor Julie is interested in a car with all wheel drive, denoted as AWD in the table. What is the probability that a car make and model is available in AWD? Include any of the drive wheel categories that have the ppssibility of AWD, E.g also include the categories Front, AWD, 4WD and Rear, AWD, 4WD as possibilities. Show your calculations in your answer explanation. 4. What is the probability that a car make and model is only available in Front wheel drive and is a station wagon? E.g do not include the categories Front, AWD, 4WD as possibilities. Show your calculations in your answer explanation. 5. What is the probability that a car is a hatchback or only available in Front wheel drive? Show your calculations in your answer explanation. Part 4: Normal Approximation Models (200 points) 1. Create a histogram of the variable horsepower, coded as HP in the dataset. When you create the histogram, scroll down to Display Choices. Include an overlay of the normal distribution by choosing Overlay distrib. Normal in the pull down choices. Record the mean and standard deviation of the Normal distribution overlay here. Include a screenshot or image of the graph here. 2. Professor Julie's current car has horsepower 147 HP. Using the mean and standard deviation from the Normal distribution overlay that you found in question #1, find the Z-stat (also known as the Z-score) for a car with horsepower 147 HP. Show your calculations. Type the math calculations as best as you can. You can use the symbol or () to represent multiplication and use / symbol to represent division 3. Find the probability that a car has less than 147 HP. Use the StatCrunch Normal Calculator and the mean and standard deviation from the Normal distribution overlay that you found in question #1 to answer this question. The Normal Calculator is found by selecting Stat -> Calculators -> Normal. Include a screenshot or image of the graph here. 4. Find the probability that a car has more than 147 HP. Use the StatCrunch Normal Calculator and the mean and standard deviation from the Normal distribution overlay that you found in question #1 to answer this question. The Normal Calculator is found by selecting Stat -> Calculators -> Normal. Include a screenshot or image of the graph here. 5. Find the probability that a car has between 150 HP and 350 HP. Use the StatCrunch Normal Calculator and the mean and standard deviation from the Normal distribution overlay that you found in question #1 to answer this question. The Normal Calculator is found by selecting Stat -> Calculators -> Normal. Include a screenshot or image of the graph here. Part 5: Making a Recommendation (25 points) Professor Donovan is considering buying a new car. Here are her preferences: Parent Company USA or Japan, Lowest MSRP cost under $35000, seats at least 5, Wagon, SUV, or Minivan, MPG above 20, Wheelbase over 100 inches. Use the graphs you made in Part 2 and scroll through the data set to find some cars that might be a match. Recommend at least two cars for Professor Julie to choose from

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

Students also viewed these Accounting questions