Make a list of three cars that you would consider purchasing

Assignment Help Basic Statistics
Reference no: EM13869887

Using Microsoft Excel,suppose you are in the market to purchase a used car. To make an informed decision regarding your purchase, you would like to collect as much information as possible. Among the information you might consider are the typical price of the car, the typical number of miles the car should have, and its crash test results, insurance costs, and expected repair costs.

1. Make a list of at least three cars that you would consider purchasing. To be fair, the cars should be in the same class (compact, midsize, etc). they should also be of the same age.

2. Collect information regarding the three cars in your list by finding eight cars of each that are for sale. Obtain such information as the asking price and the number of miles the car has. Sources of data include your local newspaper, classified ads, and car websites (www.cars.com and www.vehix.com). Compute the summary statistics for asking price, number of miles, and other variables of interest. Remember, thesummary statistics include min, max, mean, median, mode, range, variance, standard deviation, and so on.

Write a report (4-5 paragraphs) with supporting data supporting your conclusion regarding which car you would purchase and why. Be sure to include all relevant statistics in your written report. Attach the Excel sheet used for the primary data source.

Reference no: EM13869887

Previous Q& A

  Discuss the elements of burning related to arson

Discuss the willful and malicious intent related to arson. Discuss the elements of burning related to arson. Discuss the issues surrounding the definition of a dwelling. Discuss burning with the intent to defraud an insurer

  Formulate a linear programming model for the given problem

Formulate a linear programming model for this problem. Solve the model with Excel Solver. Interpret your solution. If you have the chance to buy additional land at the price of $50 per acre, would you prefer to do so? What if the price would be $70..

  Important elements in the formation of a contract

The two important elements in the formation of a contract are offer and acceptance. There are rules and exceptions to these two closely connected elements. Set out the LAW regarding these two elements

  Fba summary such as the behavior analytic problem solving

discuss why it's inclusion is relevant to the development of the FBA Report identify the specific section of the FBA Report

  Environmental effects of water pollution

what types of general recommendations do you have for meeting the issues you have identified? Ensure that you locate, identify, analyze, and evaluate the public health and environmental effects of water pollution and the regulatory recommendations..

  Does the bible forbid carl to file bankruptcy

Does the Bible forbid Carl to file bankruptcy? Does the Bible forbid borrowing altogether? If not, when is it permissible to borrow money?

  Discuss moral argument in peter singers solution to poverty

In this project you are asked to discuss the moral argument in Peter Singer's "Solution to Poverty." What issues do they address? What moral perspectives do they embody? What technique of reasoning does he use?

  Briefly describe the pseudoscience phenomenon

Briefly describe the pseudoscience phenomenon that you are focusing on (feel free to cite one or two online sources for illustrative purposes).

  Calculate the sample average

a. Calculate the sample average b. Calculate the sample standard deviation c. Based only on this information do you have a normally distributed process?

  Why are most people ignorant about contemporary slavery

Why are most people ignorant about contemporary slavery? If a person willingly enters into slavery, is it still slavery

Reviews

Write a Review

 

Similar Q& A

  How many expect to have tasted either coke or pepsi

Assume that 80% of the adult population in the United States has tasted either Coke or Pepsi. For a sample of 250 adults, How many would you expect to have tasted either Coke or Pepsi? Whats the variance?

  Test of regression coefficient using spss

Fit a linear regression model for bp against sodium. Do you think this is a model with a good fit? Why?

  Find the intercept and slope and write the regression

question a local tire dealer wants to predict the number of tires sold each month. he believes that the number of tires

  Determine a 95 confidence interval for the population

given below are the values taken from a normal population.21 23 25 27 28 35 30 32 33determine a 95 confidence

  1a study of cardiovascular risk factors compared heavy

1.a study of cardiovascular risk factors compared heavy smokers light smokers and nonsmokers. both men and women were

  Computing p-value for one sample mean test

Over a period of years, toothpaste has received a mean rating of 5.9, on a 7-point scale, for overall customer satisfaction with the product.

  Hypothesis test for single factor-anova

Complete the table and answer the following questions. Use the .05 significance level.

  Diameters of peaches in a certain orchard

The diameters of peaches in a certain orchard are normally distributed with a mean of 3.85 inches and a standard deviation of 0.42 inches. Show all work.

  The probability density function of the random variable x

the probability density function of the random variable x is given by fx 32x2 -1ltxlt1 0 elsewhere.a. find the

  To test the hypothesis h0 100 vs h1 gt 100 a z-score of

to test the hypothesis h0 ? 100 vs. h1 ? gt 100 a z-score of 2.8 is calculated. the probability of observing a z-score

  The air in poultry-processing plants often contains fungus

the air in poultry-processing plants often contains fungus spores. inadequate ventilation can affect the health of the

  Suppose x the number of flaws in a roll of polyethylene

suppose x the number of flaws in a roll of polyethylene insulated cable follows a poisson process where lambda is 1.1

Free Assignment Quote

Assured A++ Grade

Get guaranteed satisfaction & time on delivery in every assignment order you paid with us! We ensure premium quality solution document along with free turntin report!

All rights reserved! Copyrights ©2019-2020 ExpertsMind IT Educational Pvt Ltd