Math 533- 64541

1. (TCO A) Consider the following sample data on the age of the 30 employees that were laid off recently from DVC Inc.21         38         20         26         37         52         37         24         45         2050         49         44         30         29         42         56         46         60         3032         25         47         55         38         25         20         29         32         30a. Compute the mean, median, mode, and standard deviation, Q1, Q3, Min, and Max for the above sample data on age of employees being laid off.b. In the context of this situation, interpret the Median, Q1, and Q3. (Points : 33)2. (TCO B) Consider the following data on newly hired employees in relation to which part of the country they were born and their highest degree attained.HSBSMSPHDTotalEast352111Midwest792018South586221West178622Total162918972If you choose one person at random, then find the probability that the persona. is from the Midwest.b. is from the South and has a PHD.c. is from the West, given that person only holds a MS degree. (Points : 18)3. (TCO B) A source in the Internal Revenue Service has stated that historically 90% of federal tax returns filed are free of arithmetic errors. A random sample of 25 returns are selected and checked carefully for arithmetic errors. Assuming independence, find the probability thata. all 25 returns are free of arithmetic errors.b. at most 23 returns are free of arithmetic errors.c. more than 17 are free of arithmetic errors. (Points : 18)4. (TCO B) The Bank of Connecticut issues Visa and Mastercard credit cards. The balances on these credit cards follow a normal distribution with a mean of $845 and standard deviation of $270.a. What percentage of balances is below $1,200?b. What percentage of balances is between $600 and $1,000?c. Find the 12th percentile for balance (i.e., find the cutoff for the lowest 12% of balances). (Points : 18)Question 5.6. (TCO C) The personnel manager of a large firm wants to find the percentage of employee absences that occur on Fridays. A random selection of 500 employee absences is taken from work records over the past several years. The data reveals that 220 of the 500 employee absences were on Fridays.a. Compute the 99% confidence interval for the population proportion of absences that are on Friday.b. Interpret this confidence interval.c. How large a sample size will need to be selected if we wish to have a 99% confidence interval that is accurate to within 3%? (Points : 18)8. (TCO D) Engineering studies show that it is feasible to install a windmill for generating electrical power if the mean wind speed is greater than 14 mi per hour (mph). The Piedmont Electric Co-op is considering locating mulls at the top of Mount Hunter. A random sample of 45 wind speed readings yields the following results.Sample Size = 45Sample Mean = 14.9 mphSample Standard Deviation = 3.8 mphDoes the sample data provide sufficient evidence to conclude that installation is feasible at this location (using a = .10)? Use the hypothesis testing procedure outlined below.a. Formulate the null and alternative hypotheses.b. State the level of significance.c. Find the critical value (or values), and clearly show the rejection and nonrejection regions.d. Compute the test statistic.e. Decide whether you can reject Ho and accept Ha or not.f. Explain and interpret your conclusion in part e. What does this mean?g. Determine the observed p-value for the hypothesis test and interpret this value. What does this mean?h. Does the sample data provide sufficient evidence to conclude that installation is feasible at this location (using a = .10)? (Points : 24)1. (TCO E) McCave Development Enterprises is considering whether to build a shopping mall in Statesville. The manager wants you to analyze the relationship between mall size and the rate of return on invested capital. You select a random sample of 16 cities similar to Statesville in demographic and economic characteristics and collect the following data on FOOTAGE (in 10,000 square feet) and RETURN (rate of return as a %).RETURNFOOTAGEPREDICT18.312.815.011.718.67.519.510.317.514.315.414.29.821.411.418.614.516.716.315.519.09.817.014.215.116.219.512.810.919.416.315.016.315.4Regression Analysis: RETURN versus FOOTAGEThe regression equation isRETURN = 30.0 – 0.943 FOOTAGEPredictor      Coef  SE Coef       T      PConstant     29.976    1.238   24.22  0.000FOOTAGE    -0.94257  0.07921  -11.90  0.000S = 0.969721   R-Sq = 91.0%   R-Sq(adj) = 90.4%Analysis of VarianceSource          DF      SS      MS       F      PRegression       1  133.15  133.15  141.59  0.000Residual Error  14   13.17    0.94Total           15  146.31Predicted Values for New ObservationsNew Obs     Fit  SE Fit       95% CI            95% PI1  15.838   0.244  (15.315, 16.360)  (13.693, 17.982)2  22.907   0.666  (21.479, 24.334)  (20.384, 25.429)XX denotes a point that is an outlier in the predictors.Values of Predictors for New ObservationsNew Obs  FOOTAGE1     15.02      7.5Correlations: RETURN, FOOTAGEPearson correlation of RETURN and FOOTAGE = -0.954P-Value = 0.000a. Analyze the above output to determine the regression equation.b. Find and interpret in the context of this problem.c. Find and interpret the coefficient of determination (r-squared).d. Find and interpret coefficient of correlation.e. Does the data provide significant evidence (a = .05) that Footage can be used to predict Return? Test the utility of this model using a two-tailed test.  Find the observed p-value and interpret.f.  Find the 95% confidence interval for the mean rate of return on capital investment for malls that have square footage of 150,000. Interpret this interval.g. Find the 95% prediction interval for the rate of return on capital investment for a mall that has square footage of 150,000. Interpret this interval.h. What can we say about the rate of return on capital investment for a mall that has square footage of 75,000?(Points : 48)1. (TCO E) An insurance firm wishes to study the relationship between driving experience (X1, in years), number of driving violations in the past three years (X2), and current monthly auto insurance premium (Y).  A sample of 12 insured drivers is selected at random.  The data is given below (in MINITAB):YX1X2Predict X1Predict X274528138140506163103974655825711343161993546913519060133Regression Analysis: Y versus X1, X2The regression equation isY = 55.1 – 1.37 X1 + 8.05 X2Predictor     Coef  SE Coef      T      PConstant    55.138    7.309   7.54  0.000X1         -1.3736   0.4885  -2.81  0.020X2           8.053    1.307   6.16  0.000S = 6.07296   R-Sq = 93.1%   R-Sq(adj) = 91.6%Analysis of VarianceSource          DF      SS      MS      F      PRegression       2  4490.3  2245.2  60.88  0.000Residual Error   9   331.9    36.9Total           11  4822.3Predicted Values for New ObservationsNew Obs    Fit  SE Fit      95% CI          95% PI1  52.20    2.91  (45.62, 58.79)  (36.97, 67.44)Values of Predictors for New ObservationsNew Obs    X1    X21  8.00  1.00Correlations: Y, X1, X2Y      X1X1  -0.8000.002X2   0.933  -0.6600.000   0.020Cell Contents: Pearson correlationP-Valuea. Analyze the above output to determine the multiple regression equation.b. Find and interpret the multiple index of determination (R-Sq).c. Perform the t-tests on  and on  (use two tailed test with (a = .05). Interpret your results.d. Predict the monthly premium for an individual having 8 years of driving experience and 1 driving violation during the past 3 years. Use both a point estimate and the appropriate interval estimate.(Points : 31)