• Home
  • Blog
  • QMM Quantitative Methods for Managers Using Excel And JMP 6 Questions

QMM Quantitative Methods for Managers Using Excel And JMP 6 Questions

0 comments

PLEASE ADD JMP OUTPUTS AS IMAGES AND HIGHLIGHT ANSWERS

undefined

Question 1

undefined

A light bulb manufacturer would like to advertise that their new CFL bulb has an average life of longer than 8,000 hours.To evaluate the bulb lifetime, you test a random sample of 36 CFL bulbs and record the number of hours of usage until the bulb fails.The data appear in the Light bulb worksheet of the QMM5100 W21 data workbook on Moodle.

undefined

a)Perform a hypothesis test to validate the advertising claim.Place your JMP output on the Light bulb worksheet of your QMM5100 W21 data workbook.Using a = 0.05, draw a conclusion for the hypothesis test.Your answer should include the p-value and be stated in the context of the problem.

undefined

undefined

b)Using this data, what is the largest value that you can conclude the mean number of hours of usage until the bulb fails exceeds at a = 0.05?Place your JMP output on the Light bulb worksheet of your QMM5100 W21 data workbook.

undefined

c)If the true average life of the CFL light bulb is 8,100 hours, what is the probability that their new CFL bulb has an average life of longer than 8,000 hours with a sample of n = 36 at a = 0.05, i.e., determine the power of the test.Place your JMP output on the Light bulb worksheet of your QMM5100 W21 data workbook.

undefined

undefined

d)If the true average life of the CFL light bulb is 8,100 hours, what sample size should you take so that you would conclude the alternative hypothesis of part a) at a = 0.05 with probability of at least 0.80.Place your JMP output on the Light bulb worksheet of your QMM5100 W21 data workbook.

undefined

Question 2

undefined

Researchers at the Mayo Clinic have studied the effect of sound levels on patient healing and have found a significant association (louder hospital ambient sound level is associated with slower postsurgical healing).However, the study also shows patients are sensitive to the variance in sound levels.Based on the Mayo Clinic’s experience, Ardmore Hospital installed a new vinyl flooring that is supposed to reduce the mean sound level (decibels) in the hospital’s main corridor.To test the hypothesis, the sound level is measured at five randomly selected times in the main corridor and at five randomly selected times in other corridors.The data appear in the Decibels data worksheet in the QMM5100 W21 data workbook on Moodle.Use JMP to perform the hypothesis test of part a).

undefined

a) Use a hypothesis test to show the mean sound levels is different between the new flooring (installed in the main corridor) and the old flooring in the rest of the hospital.Place your JMP output on the Decibels worksheet of your QMM5100 W21 data workbook.Using a = 0.05, draw a conclusion for the hypothesis test.Your answer should include the p-value and be stated in the context of the problem.

undefined

b) Use a hypothesis test to show the variance in sound levels is different between the new flooring (installed in the main corridor) and the old flooring in the rest of the hospital.Place your JMP output on the Decibels worksheet of your QMM5100 W21 data workbook. Using a = 0.05, draw a conclusion for the hypothesis test.Your answer should include the p-value and be stated in the context of the problem.

undefined
undefined

Question 3

undefined

A statistics professor is studying the learning styles of college students.The professor would like to determine the effect of material delivery method on comprehension.The study included four delivery methods: traditional classroom lecture, on-line, hybrid (classroom and on-line), and self-study.The professor randomly divided his class of 80 students into four groups of 20 students with each group using one of the delivery methods.At the end of the study period, all 80 students took the same 20 question multiple choice test.The data appear in the Test Score worksheet in the QMM5100 W21 data workbook on Moodle.

undefined

  • Place your JMP output on the Test Score worksheet of your QMM5100 W21 data workbook.Using a = 0.05 draw a conclusion for the ANOVA.Make sure you state your conclusion in the context of the problem.
  • Place your JMP output on the Test Score worksheet of your QMM5100 W21 data workbook. Using a = 0.05, draw conclusions for the hypothesis tests.Your answers should include p-values and be stated in the context of the problem.
  • Place your JMP output on the Test Score worksheet of your QMM5100 W21 data workbook. Interpret these values in the context of student comprehension as measured by test score.

undefined

undefined

d) Use a hypothesis test to determine if the data meets the model assumption of equal variance.Place your JMP output on the Test Score worksheet of your QMM5100 W21 data workbook.Using a = 0.05, draw a conclusion for the hypothesis test.Your answer should include the p-value and be stated in the context of the problem.

undefined
undefined

Question 4

undefined

Larry Swattle, a local attorney, is interested in understanding the relationship between the outside temperature and his energy usage.Larry finds his electric bills for the last 24 months and records the electric consumption in Kilowatt Hours.He then uses the internet to find the average monthly temperature in Fahrenheit for his city for those months.The data appear in the Electricity worksheet of the QMM5100 W21 data workbook on Moodle.

undefined

a)Fit the simple linear regression model using monthly electric consumption as the dependent or Y variable and average daily temperature as the dependent or X variable. Place your JMP output on the Electricity worksheet of your QMM5100 W21 data workbook.Provide the equation of the fit line.Interpret the parameter estimates in the context of the problem.

undefined

b) Use a hypothesis test to determine if the decrease in electric consumption for a one unit (degree) increase in average daily temperature is more than 7.50 Kilowatt Hours.Place your JMP output on the Electricity worksheet of your QMM5100 W21 data workbook.Usinga = 0.05, draw a conclusion for the hypothesis test.Your answer should include the p-value and be stated in the context of the problem.

undefined

c)Next month is forecasted to have an average daily high temperature of 50 degrees.Provide a 95% prediction interval for the Electric Consumption for next month.Place your JMP output on the Electricity worksheet of your QMM5100 W21 data workbook.

undefined

undefined

undefined

undefined
undefined

Question 5

undefined

Sam Lender, a home equity loan manager, is studying the relationship of applicant Income (in thousands of dollars) to home Value (in thousands of dollars), Education, Age, current monthly mortgage Payment (in dollars), and Gender (Male or Female).The data appear in the Sam Lender data worksheet of the QMM5100 W21 data workbook on Moodle.

undefined

a) Fit a multiple regression model that uses Income as the dependent or Y variable and Value and Gender as independent or X variables.Place your JMP output on the Sam Lender worksheet of your QMM5100 W21 data workbook.

undefined

b) Describe how a sketch your regression model would appear in the Income (Y) – Value (X) plane.Your description should include the number of lines and their relationship to each other, e.g., three lines with two parallel.For each line you should indicate the category it represents and include values for the slope and intercept.

undefined

c) Using your regression model in part a), provide a point prediction and a 95% prediction interval for the Income for a 50 year-old Male mortgage loan applicant whose home has a value of 150 (in thousands of dollars), has an education level of 14 and has a current monthly mortgage payment of $500.Place your JMP output on the Sam Lender worksheet of your QMM5100 W21 data workbook.

undefined
undefined

Question 6

undefined

The manager of a physical plant department at a regional Midwestern university is interested in reducing the average time to completion of routine work orders.The time to completion is defined as the difference between the date of receipt of a work order and the date closing information is entered.The number of labor hours charged to each work order, the cost of materials and building type (classified into four types on the campus: residence halls, athletic, academic, and administrative ) are variables believed to be related to the time to completion of the work order.The manager also constructed the interaction of Hours and Material and the quadratic term Hours2.A random sample of 72 work orders was obtained.These data appear in the University data worksheet in the QMM5100 W21 data workbook on Moodle.

undefined

a)Fit a multiple regression model using Days as the Y or dependent variable with independent variables of Hours, Material, and the Hours^2 quadratic term. Place your JMP output on the University data worksheet of your QMM5100 W21 data workbook.Interpret the coefficients of the model in part a) in the context of the problem.Include an assessment of their statistical significance at a = 0.05.

undefined

undefined

undefined

b)Using the model in part a), construct a 95% confidence interval for the average number of days to complete a work order for an administrative building that requires 3 hours, and $20 of material.

undefined

undefined

undefined

c)You determine that the work order initially thought to require 3 hours and $20 material will require an additional $10 in material (an increase from $20 to $30).Using the model in part a) what is the expected change in days to complete the work order?

Please accept this job only if you are 100% sure.

About the Author

Follow me


{"email":"Email address invalid","url":"Website address invalid","required":"Required field missing"}