MATERIAL NEEDED TO COMPLETE MILESTONE:

Week 8: Milestone 3 (100 points)

In Week 8, populate the following sections in the Course Project template tutorial and example document.

Lessons Learned

Conclusions

Recommendations

Bibliography

The Milestone 3 deliverables are listed below.

Deliverable: Classify Various Models and Their Characteristics (50 points)

Which of the following statements is not one of the important issues defining types of arrivals in a queuing system?

Whether customers arrive one at a time or in batches

Whether customers are all essentially alike or are in separate priority classes

Whether customers have been through the system before or not

Whether customers will wait in line or not

When a customer already in line in a queuing system becomes impatient and leaves the system before starting service, what is this called?

Name one type of service discipline.

A queuing system where customers join a single line and then are served by the first available server are said to be what?

A requirement for steady state analysis of a queuing system is that _____.

The exponential distribution is _____.

The parameter l in an exponential distribution can be interpreted as a what?

Deliverable: Perform Regression Analysis to Determine a Course of Action Intended to Deal With a Business Problem (50 points)

Scenario: The station manager of a local television station is interested in predicting the amount of television (in hours) that people will watch in the viewing area. The explanatory variables are: X1 age (in years), X2 education (highest level obtained, in years), and X3 family size (number of family members in household). The multiple regression output is shown below:

Summary Measures

Multiple R

0.8440

R-Square

0.7123

Adj R-Square

0.6644

StErr of Estimate

0.5598

ANOVA Table

Source

df

SS

MS

F

p-value

Explained

3

13.9682

4.6561

14.8564

0.0000

Unexplained

18

5.6413

0.3134

Regression Coefficients

Coefficient

Std Err

t-value

p-value

Constant

1.683

1.1696

1.4389

0.1674

Age

-0.0498

0.0199

-2.5018

0.0222

Education

0.2135

0.0503

4.2426

0.0005

Family Size

0.0405

0.0784

0.5168

0.6116

Instructions:

Using Microsoft Excel as well as the Excel Add-ins that you have used throughout this course, complete all parts of the question.

Show all of your work for each step. You will need to copy and paste from your Excel spreadsheets for each step as appropriate.

Refer to the scenario. Using the information above to estimate the linear regression model. Place your answer here and show your work.

Refer to the scenario. Interpret each of the estimated regression coefficients of the regression model above. Place your answer here and show your work.

Refer to the scenario. Identify and interpret the percentage of variation explained (R2) for the model. Place your answer here and show your work.

Assignment status: Already Solved By Our Experts

(USA, **AUS**, UK & CA PhD. Writers)