Create a spreadsheet model and determine linear regression, Basic Statistics

1. MMC's CEO, Dr. Warren A. Beatty (Not the actor) believes that the demand trend for MMC is essentially linear. Thus, he wishes to determine if linear regression would be an effective forecasting method.

a. Calculate a forecast for 2010 using linear regression. Place your results in a worksheet tab named Q2.

b. Based on your calculations, is your model likely to be a valid forecasting tool? Place your answer in tab Q2.

2. Do problem 4-13 in your text. Create a spreadsheet model and use it for your analysis. Name your spreadsheet tab

3. Do problem 5-26 in your text. Create a spreadsheet model and use it for your analysis. Name your spreadsheet tab Q4

4. The smallest defect in a computer chip will render the entire chip worthless. Therefore, tight quality control measures must be established to monitor the chips. In the past, the percentage defective for these chips for a California-based company has been 1.1%. The sample size is 1,000. Determine the upper and lower control-chart limits for these computer chips. Use z = 3. Create a spreadsheet model and use it for your analysis. Name your spreadsheet tab Q5.

5. Barbara Schwartz's Office Supply Company manufactures paper clips and other office products. Although inexpensive, paper clips have provided Barbara with a high margin of profitability. The percentage defective for paper clips produced by Office Supply Company has been averaging 2.5%. Samples of 200 paper clips are taken. Establish the upper and lower control-chart limits for this process at 99.7% confidence. Create a spreadsheet model and use it for your analysis. Name your spreadsheet tab Q6.

6. Daily samples of 100 power drills are removed from Drill Master's assembly line and inspected for defects. Over the past 21 days, the following information has been gathered. Develop a 3 standard deviation (99.7% confidence) p-chart and graph the samples. Is the process in control? Create a spreadsheet model and use it for your analysis. Name your spreadsheet tab Q7.

DAY

1

2

3

4

5

6

7

8

9

10

11

12

13

14

15

16

17

18

19

20

21

Number of Defects

6

5

6

4

3

4

5

3

6

3

7

5

4

3

4

5

6

5

4

3

7

7. A random sample of 100 Modern Art dining room tables that came off the firm's assembly line is examined. Careful inspection reveals a total of 2,000 blemishes. What are the 99.7% upper and lower control limits for the number of blemishes? If one table had 42 blemishes, should any special action be taken? Create a spreadsheet model and use it for your analysis.

Name your spreadsheet tab Q8.

Posted Date: 2/28/2013 1:23:07 AM | Location : United States







Related Discussions:- Create a spreadsheet model and determine linear regression, Assignment Help, Ask Question on Create a spreadsheet model and determine linear regression, Get Answer, Expert's Help, Create a spreadsheet model and determine linear regression Discussions

Write discussion on Create a spreadsheet model and determine linear regression
Your posts are moderated
Related Questions
Barker Company has a single product called a Zet. The company normally produces and sells 80,000 Zets each year at a selling price of $40 per unit. The company’s unit costs at this

i have a scaled data on multiple questions from two different tests taken at different times for the same respondents, and now i want to calculate the reliability test manually but

1. Compute the z scores for the following raw scores where   = 78 and the standard deviation = 4. a. 72 b. 82 c. 78 d. 87 e. 71

Ask question #MinimumAgency revenues. An economic consultant was retained by a large employment agency in a metropolitan area to develop a regression model for predicting monthly a

explain the characteristics of statistics

Littlefield Laboratories is a state-of-the-art highly automated blood samples testing lab. The demand of blood sample testing for the previous 20 days (day 1 to day 20) are given i

1. Warm-up Exercise Volumes I, II, III, and IV of Shakespeare are in sequence next to one another in the library bookcase.  Each volume has 2" of pages and the front and back co

Choose a topic that interests you that you can explore either with the 2006 GSS. You should have one primary "dependent" variable that you are interested in (Y). This variable shou

find quartile deviation from the student test marks of your own

Analyse the different types of index numbers numbers numbers and their benefit to the Differentialgleichungen business world.