Please post in Excel Format.
Each response must include your calculations.
The accounting department at Weston Materials, Inc., a national manufacturer of unattached garages, reports that it takes two construction workers a meanof 32 hours and a standard deviationof 2 hours to erect the Red Barn model. Assume the assembly times follow the normal distribution.
Complete the following:
a Determine the z values for 29 and 34 hours. What percent of the garages take between 32 and 34 hours to erect?
1 z value for 29 hours
2 z value for 34 hours
3 percent of garages taking between 32 and 34 hours to erect.
b What percent of the garages take between 29 hours and 34 hours to erect?
percent of garages taking between 29 and 34 hours to erect.
c What percent of the garages take 28.7 hours or less to erect?
percent of garages taking less than 28.7 hours to erect.
d Of the garages, 5 percent take how many hours or more to erect?
hours needed to erect 5 percent of the garages
This solution provides assistance in determining the z-values for Weston Materials.