Homework 11 Chapter 12 & Survey Assignment Complete Solution

Question: #1790

Homework 11 (Chapter 12 & Survey Assignment)

Upload the homework in WORD or PDF format on Blackboard (Course Content >> Homework >> Homework 11)

 Follow instructions (submissions that do not follow instructions will not be graded).
 Make sure to submit on time (the upload links will not work after the due date). I will not accept this homework via email.

 Part A (Chapter 12) and Part B (Survey Assignment) will be uploaded separately. One file for part A and one file for part B, two files total. Both parts must be typed.

 File formats other than WORD/PDF will NOT be accepted or graded. Do not submit Excel files.
 Make sure your name appears on the first page at the top of the document. Nameless homework will not be graded.

Part A. Chapter 12 Problems. (14pts)

 Use full sentences and proper grammar/spelling.
 Answer each question as if I do NOT have the Excel regression output. Do NOT state that the answer “can be found in the output”, or highlight/circle sections of the output and state “here is my answer”/“see output for my answer”, or paste blocks of output in place of the answer, etc.
 Paste your Excel output where indicated. Make sure the output fits on one page. In Word, use the copy & "paste as Picture” method (to resize and maintain formatting).

Problem 1. The Food and Drug Administration (FDA) requires pharmaceutical companies to establish a shelf life for all new drug products. Pharmaceutical companies perform a stability analysis to determine how stable a drug is over time (to determine when the drug reaches unacceptable potency levels). Regression models allow pharmaceutical companies to determine the stability of the drug and establish a shelf life. This is a very simplified case that illustrates the concept. A pharmaceutical company wants to determine the shelf life of their new drug. A random sample of the drug in tablet form is placed into storage. At certain time intervals
(measured in months) a randomly selected tablet is taken out of storage and the potency is measured; e.g., if “Potency = 99%” then the potency of the tablet is 99% of what the company claims the drug potency to be. Below is the sample data (problem1_data.xls is posted on Blackboard). (8pts)
Time (X) Potency (Y)__
3 99.0
6 102.0
9 98.0
12 98.5
15 97.5
18 97.0
21 96.5
24 96.1
30 95.7
36 95.0
48 94.0
60 94.5

a. Create a scatter plot (time period goes on the x‐axis). Do you see a linear relationship? Paste scatter plot here. (1pt)
b. Using time as the independent variable (Time period = X) and potency as the dependent variable (Potency = Y), what is the estimated regression equation (write it down)? Paste regression output here. (2pts)

c. Test the significance of the regression relationship between time and potency with α = 0.05. State (1) your hypotheses, (2) your rejection rule, (3) the p‐value, and (4) the conclusion. (2pts)
d. What is the r2 for this model? What does this suggest about how well the estimated regression model fits the data? (2pts)

e. Predict the potency level for a time of 19 months. (1pt)

Problem 2. Accu‐Copiers, Inc., sells and services the Accu‐750 copying machines. As part of its standard service contract, the company agrees to perform routine service on this copier. To obtain information about the time it takes to perform routine service, Accu‐Copiers has collected data for 10 service calls. The company wishes to predict the amount of time (in minutes) it takes to perform a service based on the number of copiers being serviced (problem2_data.xls is posted on Blackboard). (6pts)
Copiers (X) Minutes (Y)
4 110
2 58
5 138
7 188
1 37
3 82
4 104
5 130
2 70
4 112
a) Create a scatterplot of the data. Do you see a linear relationship between the number of copiers serviced and the total time it took to perform the service? Paste scatter plot here. (1pt)
b) Use Excel to generate regression output. What is the estimated regression equation that relates the time in minutes to the number of copiers serviced (write it down)? Paste regression output here. (2pts)
c) Use your estimated regression equation from part (b) to predict the time to service 8 copiers. (1pt)
d) Find the coefficient of determination and write it down. What does it tell you? Is this a good model? (2pts)

Part B. Survey report. (14 pts)
1. Formatting:
 Follow the template (report_template.docx posted on Blackboard).
 Use an 11 point font and 0.7 inch margins. Single spaced.
 Use full sentences and proper grammar/spelling. No lists or bullet points.
 Properly label and name all your graphs/charts. Copy & “paste as Picture” from Excel into Word.
 Keep the body of the report to just one page. (NOTE: The Appendix, with calculations and the two graphs/charts, does NOT count towards the report length).
 You may wish to review Chapters 2, 3, and 8.
2. The report is meant to be your reflection on the data collection process as well as a brief presentation of your findings. Points you should address in your report:

 What was your question? Is your data qualitative or quantitative? How many responses did you
obtain? Why is the sample size important?
 We are treating this as a sample from a population (and not a census). What population(s) could this sample represent?
 What are your sample statistics (sample mean and standard deviation, or sample
proportions/percentages)?
 Create a percent frequency distribution (i.e., list each category and the corresponding percentage;
refer to Chapter 2).
 Create two graphs/charts and a confidence interval for the population mean or proportion (for
qualitative data, pick one category and create a confidence for that proportion, you do not need to
create confidence intervals for each category). Refer to Chapter 8.
 Consider the information obtained from the confidence interval. Compare it to your initial
expectations.

 Describe what each graph/chart is showing in the body of the report. E.g., “The pie chart in Figure 1 of the Appendix illustrates that … is the majority opinion …”
 What issues, if any, did you run into while working with the collected data? How did you handle
them? If you were to re‐do this exercise, what would you change? Why?
 Tell me what you have learned from this sample and this exercise.
Grading. The report is worth 14 points:
 7 points for the appendix work (confidence interval, two graphs/charts, % frequency distribution).
 7 points for the report content and format (i.e., did you follow the instructions). The report should have a proper beginning, middle, and end (it should NOT be a list of items or a disjoint set of replies to a set of questions). If I cannot understand your report (e.g., due to spelling/grammar) you will not receive credit for it. You will lose points if there are multiple spelling and grammatical errors.

Solution: #1771

Homework 11 (Chapter 12 & Survey Assignment) Complete Solution

The scatter plot depicts a strong linear relationship between Potency and Time, as the points plotted on the scatter plot are around a straight line. b). Using tim...