Statistics Analysis

Anonymous
timer Asked: Apr 26th, 2017

Question description

Data set 2 presents a sample of the number of defective flash drives produced by a small manufacturing company over the last 30 weeks. The company’s operations manager believes that the number of defects produced by the process is less than seven defective flash drives per week.

Use Excel’s Analysis ToolPak to compute the regression equation for predicting the number of defective flash drives over time (in weeks), the correlation coefficient r and the coefficient of determination R2.

Submit your statistical output from Excel, which should include values for the

slope, y-intercept, regression equation, r, and R2.

Submit a Word file that includes the hypothesis test. Specifically, the following critical elements must be addressed:

I.

Methodology

II.

Analysis

Guidelines for Submission:

Submit a 1-page Word document with spreadsheet..

A finance manager employed by an automobile dealership believes that the number of cars sold in his local market can be predicted by the interest rate charged for a loan. Interest Rate (%) Number of Cars Sold (100s) 3 10 5 7 6 5 8 2 The finance manager performed a regression analysis of the number of cars sold and interest rates using the sample of data above. Shown below is a portion of the regression output. Regression Statistics Multiple R 0.998868 R2 0.997738 Coefficient Intercept 14.88462 Interest Rate -1.61538 Specially, the following critical elements must be addressed; Main elements: • Are there factors other than interest rate charged for a loan that the finance manager should consider in predicting future car sales? Integration and Application: • Is interest rate charged for a loan the most important factor to be considered in predicting future car sales? Explain your reasoning. • The dealership’s vice-president of marketing has requested a sales forecast at the prevailing interest rate of 7%. Analysis: • As finance manager, what reasons would you convey to the vice-president in recommending this forecasting model? Critical Thinking • Is the prediction of car sales at 7% a reflection of the current downturn in the economy? How might this impact the dealership’s business? Analysis of this scenario should be 1-2 page Microsoft word document with double spacing and 12 point Times New Roman font
Week 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 #Flashdrives 6 7 6 5 7 5 6 6 8 9 9 7 5 6 8 8 9 7 6 8 5 7 6 8 10 9 7 8 7 6 Number of Defective Flashdrives for 30 Weeks Flashdrives for 30 Weeks
Studypool has helped 1,244,100 students
flag Report DMCA
Similar Questions
Hot Questions
Related Tags
Study Guides

Brown University





1271 Tutors

California Institute of Technology




2131 Tutors

Carnegie Mellon University




982 Tutors

Columbia University





1256 Tutors

Dartmouth University





2113 Tutors

Emory University





2279 Tutors

Harvard University





599 Tutors

Massachusetts Institute of Technology



2319 Tutors

New York University





1645 Tutors

Notre Dam University





1911 Tutors

Oklahoma University





2122 Tutors

Pennsylvania State University





932 Tutors

Princeton University





1211 Tutors

Stanford University





983 Tutors

University of California





1282 Tutors

Oxford University





123 Tutors

Yale University





2325 Tutors