Create a spreadsheet model and determine linear regression, Basic Statistics

Assignment Help:

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.


Related Discussions:- Create a spreadsheet model and determine linear regression

Classification of raw data with example tables, Classification of raw data ...

Classification of raw data on the basis of homogeneous characteristics

Four characteristics and functions of statistics, highlight four characteri...

highlight four characteristics and four functions of statistics

Nuclear spin, Nuclear spin All nucleons (protons or neutrons) are spin par...

Nuclear spin All nucleons (protons or neutrons) are spin particles. They have spin odd half multiple of h = (h/2p) they follow Fermi disc statistics or Pauli’s exclusion principle

Time quantization and amplitude quantization, A sine wave is sampled at int...

A sine wave is sampled at interval Tand quantixed using N=2bits precision over the range ±1. The sine wave has peroid τ, and T is chosed such that T = 1/8τ Plot one cycle of the

Correlation coefficient for X and Y, Calculate Correlation coefficient for ...

Calculate Correlation coefficient for X and Y, Statistics Homework • Variable X x • Variable Y y • Calculate: • z-scores for all values in the variables • correlation coefficien

Linear modelling, what is a difference between a linear model and a linear ...

what is a difference between a linear model and a linear model

Reply plz, order tomatoes in crates of 25 kg and he is able to stock a maxi...

order tomatoes in crates of 25 kg and he is able to stock a maximum of four crates or 100 kg of tomatoes. His experience taught him that the daily demand ranges from 0 to100 kg of

Bartlett test, what are the statistics hypotheses for bartlett''s test for ...

what are the statistics hypotheses for bartlett''s test for exponential distribution?

Basis of accounting, Basis of accounting This represents the technique and...

Basis of accounting This represents the technique and time of when income and costs or costs are acknowledged in the records and revealed in the fiscal reports. Talk about ACCRUAL

Measures of central tendency, MEASURES OF CENTRAL TENDENCY: 1) What do...

MEASURES OF CENTRAL TENDENCY: 1) What do you mean by the term "Statistics"? Also state the importance of statistics. 2) What is the difference between mean, median and mode

Write Your Message!

Captcha
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