Tracway International, Inc., a privately owned designer and producer of traditional lawn mowers used by homeowners, is headquartered in St. Louis, Missouri, and with manufacturing plants in St. Louis, Missouri; Greenwood, South Carolina; Camarillo, California, and Providence, Rhode Island. Charlie Wong has recently joined the management team of the company to oversee Tracway’s production operations and you are his chief data analyst.

Before digging into the details of the company’s operations, Charlie Wong wants to gain an overview of Tracway’s overall business performance and market position by examining the information in the Tracway.Xls . Specially, he is asking you to:

Question #1

Construct frequency distribution s and histograms for the overall data, i.e., without separating into regions, in the worksheet C3 2005 Customer Survey for all four variables. The variables are measured on a scale of 1-5 (1 = poor, 2 = less than average, 3 = average, 4 = above average, and 5 = excellent). Make conclusions. [Note: Bins of the histograms must correspond to the scale of the survey.]

Question #2

Using once again the C3 2005 Customer Survey data and focusing only on the price and service variables, construct frequency distributions and histograms for the North America (NA) and China regions. Make conclusions? [Note: Bins of the histograms must correspond to the scales of the survey.]

Question #3

Based on the information given in the worksheets: C5 Mower Unit Sales , C6 Tractor Unit Sales , C7 Industry Mower Total Sales , and C8 Industry Tractor Total Sales , determine and show by using line charts how sales of mowers and tractors compare with industry totals? Also, how strongly are monthly product sales correlated with industry sales? [Note: Compare sales of mower in one chart and then sales of tractor in the other chart.]

Question #4

Use information in the worksheet I4 Response Time to determine what estimates can we give customers for response times to customer service calls with reasonable assurance ? [Note: (1) The data provides samples of the times taken by Tracway customer service personnel to respond to service calls by the quarter beginning in 2004, and (2) a 95% confidence will be considered as reasonable assurance].

Question #5

High rate of turnover in the company field service staff is a main concern of Charlie, and you will conduct a statistical study to determine the effect that years of education , college grade point average , and age when hired have on retention . The information required for this task is complied in the S6 Employee R etention worksheet. Use techniques of regression analysis to evaluate the data in the worksheet and make conclusions .

Question #6

To remain competitive, Tracway needs to keep up with the latest in production technology. When new production technology is introduced, firms often experience learning, resulting in a gradual decrease in the time required to produce successive units. One example is the production of a new design for lawn mower engines.

To determine the time required to produce these engines, Tracway produced 50 units on its production line, and the test results are given on the worksheet S1 Engines . Because understanding the rate of learning is crucial in estimating future production cost, you would like to conduct a statistical study on this. Once again use techniques of regression analysis to evaluate the data in the worksheet and make conclusions . [Hint: You need to create a trend variable which goes from 1, 2, 3, to n as the independent variable of the regression.]

Price: $25.52

Solution: The downloadable solution consists of 17 pages, 852 words and 15 charts.
Deliverable: Word Document