Purchase Solution

Using Excel's COUNTIF for a Mileage Problem

Not what you're looking for?

Ask Custom Question

Bridgestone has produced a new tire with an estimated mean lifetime mileage of 36,500. Management also believes that the standard deviation is 5,000 miles and that tire mileage is normally distributed. Use worksheet to simulate the miles obtained for a sample of 500 tires.

1) Use Excel COUNTIF function to determine the number of tires that last longer than 40,000 miles. What is your estimate of the % of tires that will exceed 40,000 miles?

2) Use COUNTIF to find the number of tires that obtain mileage less than 32,000 miles. Then, find the number with less than 30,000 miles and the number with less than 28,000 miles.

3) If management would like to advertise a tire mileage guarantee such that approximately no more than 10% of the tires would obtain mileage low enough to qualify for the guarantee, what tire mileage considered in number 2 would you recommend for the guarantee?

Purchase this Solution
Solution Summary

Solution attaches both an explanatory Word document and illustrative Excel spreadsheet showing how to use Excel's COUNTIF function to solve 3 mileage word problems.

Purchase this Solution
Free BrainMass Quizzes
Know Your Statistical Concepts

Each question is a choice-summary multiple choice question that presents you with a statistical concept and then 4 numbered statements. You must decide which (if any) of the numbered statements is/are true as they relate to the statistical concept.

Terms and Definitions for Statistics

This quiz covers basic terms and definitions of statistics.

Measures of Central Tendency

This quiz evaluates the students understanding of the measures of central tendency seen in statistics. This quiz is specifically designed to incorporate the measures of central tendency as they relate to psychological research.

Measures of Central Tendency

Tests knowledge of the three main measures of central tendency, including some simple calculation questions.

View More Free Quizzes
Related BrainMass Solutions

  • Usnig the Excel countif function for estimated tire miles

    221643 Usnig the Excel countif function for estimated tire miles Grear Tire company has produced a new tire with an estimated mean lifetime mileage of 36,500 miles.

  • Producing and Interpreting Descriptive Statistics

    The high and low end of the range are found using the Max and Min functions. 2. Use Excel's Mode function to calculate the mode for the number of bathrooms 3. Copy the data to a new spreadsheet. Sort the data by Price.

  • Transportation problem: Excel solver

    Using a railway city-to-city distance chart, the dispatcher constructs a mileage table for the preceding towns, as shown in the table. The table also shows the availablilities and requirements.

  • Bus Excel Project

    Sort the data by type of Bus Manufacturer and calculate the Average Cost of Maintenance for each Manufacturer      b. Sort the data by Fuel Type and calculate the cost of Maintenance and the Average Mileage by each fuel type of fuel     c.

  • Confidence Intervals In Excel Worksheet

    653669 Confidence Intervals In Excel Worksheet In this lab we will use Excel to construct a confidence intervals for the true mean mileage per gallon (MPG) for a particular SUV.

  • Descriptive Statistics & Charts

    Or, if you are using Excel 2007 or later, there is a COUNTIFS command that handles multiple conditions. Problem 1.5 Use the Baton Rouge house price data to do the following: (a) Compute the covariance between house price and house size.

  • High School Excel 2003 Questions

    Which of the following is the correct syntax for the COUNTIF function? a. =COUNTIF(criteria, field_name, list_range) b. =COUNTIF(criteria, field_range) c. =COUNTIF(field_range, criteria) d. =COUNTIF(list_range, field_name, criteria_range) e.

  • Binomial Distribution Modeling: Defective Part Rate in Manufacturing

    Student, I used Excel's binomial function to determine the answer using a null hypothesis test and have explained the steps for calculations in the attached Excel spreadsheet. Thank you for using Brainmass.

  • Analysis with a regression model: car weight and gas mileage.

    The following problem uses a regression model to answer several questions associated with auto travel. Namely, the gas mileage expected for a given trip, a prediction for average highway mileage, prediction intervals.

View More Related Solutions