statistics

Order Description

The homework has two sections:
1) Part 1: Complete Part 1 in this document, paste graphs, statistics and write answers. Please make sure that graphs and tables are properly labeled and designed to ease the understanding of the data. Upload your Excel file with your submission.
2) Part 2: Write your memo in a separate document and upload it.
3) In summery, please upload 3 files, the word decument with all the graohs and answers + the EXECEL decument showing work and grahs+ file with the memo needed. (the memo should almost be 2 pages.

Guidelines
The homework has two sections:
1) Part 1: Complete Part 1 in this document, paste graphs, statistics and write answers. Please make sure that graphs and tables are properly labeled and designed to ease the understanding of the data. Upload your Excel file with your submission.
2) Part 2: Write your memo in a separate document and upload it.
3) In summery, please upload 3 files, the word decument with all the graohs and answers + the EXECEL decument showing work and grahs+ file with the memo neede.

PART 1
The UB Bee Herald
Advertising fees are an important source of revenue for any newspaper. In an attempt to boost these revenues and to minimize costly errors, the management of the UB Bee Herald has established a task force charged with the business objective of improving customer service in the advertising department. Review the task force’s data collection (data file attached) and complete the following questions.
Organizing, Visualizing and Summarizing Data
a) Construct the graphical representation that you think it is the most appropriate for the Types of Errors and explain your choice.
Paste your graph below.

Explain your choice:

b) Create a Pareto chart to display the Cost of Advertising Errors.
Paste your graph below.

c) For the variable help desk calls, compute the appropriate numerical descriptive measures and construct a boxplot.
Paste your numerical descriptive measures below.

Paste your boxplot below.

d) For the variable help desk calls, create a histogram and describe the shape of the distribution.
Paste your histogram below.

Description:

Discrete Probability Distributions
From historical data, the percentage of customer errors that are incorrect rate quotes is 0.2583. If a sample of 20 customer errors is selected,
e) what is the probability that exactly 3 customer errors are incorrect rate quotes?

f) what is the probability of at least 5 customer errors are incorrect rate quotes?

g) what is the probability that between 3 and 5 (including 3 and 5) are incorrect rate quotes?

Normal Distribution and Sampling Distribution
The UB Bee Herald production department has embarked on a quality improvement effort. Its first project relates to the quality of the newspaper print. Each day, a determination needs to be made concerning how the newspaper is printed in terms of blackness, contrast, and sharpness. The overall rating of the print is measured on a standard scale in which the target value is 10.0. Data collected over the past year indicate that the overall rating is approximately normally distributed, with a mean of 10.5 and a standard deviation of 1.25. Each day, one page on the first newspaper printed is chosen, and the overall rating is measured. The printing of the newspaper is considered acceptable if the rating of the page is greater than 9.
h) (5 points) Assuming that the distribution has no changed from what it was in the past year, what is the probability that the overall rating is below 9?

i) (5 points) Above what overall rating 99% of the one page printing fall?

j) (5 points) If production takes a random sample of 5 pages on the first print run, what is the probability that the mean overall rating is below 9?

k) (5 points) Explain the difference in the probabilities calculated in (h) and (j).

Confidence Interval Estimation and Hypothesis Testing
The production department continues its efforts to improve quality and collected a sample of 25 ratings (data included in data file).
l) Calculate the sample statistics using the data attached and determine whether there is evidence that the population mean overall rating is less than 10.5. (Use 0.01 level of significance.)
Sample statistics:

Hypothesis:

Statistical Conclusion:

m) Calculate the p-value for this test and interpret its meaning within the context of the problem.
p-value:

Interpretation:

n) Calculate construct a 99% confidence interval estimate for the mean overall rating. Interpret the interval.
99% Confidence Interval Estimate:

Interpretation:

o) Do you think the assumption needed to construct the confidence interval estimate and conduct the hypothesis test is valid? Clearly state and support your answer with the appropriate statistical measures and graphs.
Answer:

Paste appropriate statistical measures and graphs below.

PART 2
Write a Memo to communicate to management your findings regarding the two initiatives:
1) customer service in the advertising department, and
2) printing quality (overall rating) at the production department.
You can find some information regarding memo writing here: https://owl.english.purdue.edu/owl/resource/590/1/
“The format of a memo follows the general guidelines of business writing. A memo is usually a page or two long, should be single spaced and left justified. Instead of using indentations to show new paragraphs, skip a line between sentences. Business materials should be concise and easy to read. Therefore it is beneficial to use headings and lists to help the reader pinpoint certain information.”
Your memo should be at most two pages long.
Please write your memo in a separate document. The rubric for the memo section is attached in the other file.

Advertising Department Customer Service Errors (Past Calendar Year) Cost of Advertising Errors
Type of Error Total Type of Error Amount ($000)
Copy error 45 Copy error 74.9
Layout 53 Layout 53.1
Omits 54 Omits 32.6
Pasteup 13 Pasteup 5.3
Poor reproduction 8 Poor reproduction 13
Ran in error 11 Ran in error 59.4
Rate quote 5 Rate quote 16.5
Space not ordered 13 Space not ordered 36.5
Typesetting 30 Typesetting 108.2
Velox 25 Velox 53.6
Wrong ad 7 Wrong ad 3
Wrong date 28 Wrong date 23.3
Wrong manual pasteup 6 Wrong manual pasteup 5.3
Wrong position 7 Wrong position 12.9
Wrong size 14 Wrong size 35.9