Word-process your solutions or use Excel. If using Excel, use 1 spreadsheet and label each tab
with problems. DO NOT send multiple spreadsheets.
Show all steps used in arriving at the final answers. Incomplete solutions will receive partial
Use of software package is at your discretion. You can use any software package to solve
Problems 3 5.
Be sure to clearly show the answers to each question, software generated or your computation.
10 Total Points: True or False? 1 point each, please highlight your responses or use a different font color
a. Assume that the histogram of a data set is symmetric and bell shaped, with a mean of 75 and
standard deviation of 10. Then, approximately 95% of the data values were between 55 and 95.
b. A low pvalue provides evidence for accepting the null hypothesis and rejecting the alternative.
A t-test is used to determine whether the coefficients of the regression model are significantly
different from zero.
d. Decision trees are more appropriate tools than decision tables when a sequence of decisions must
e. If a solution to an LP problem satisfies all of the constraints, then is must be feasible and
f. Correlation is measured on a scale from 0 to 1, where 0 indicates no linear relationship between
two variables, and 1 indicates a perfect linear relationship.
g. In multiple regression, the problem of multicollinearity affects the t-tests of the individual
coefficients as well as the F-test in the analysis of variance for regression, since the F-test
combines these t-tests into a single test.
In a random walk model, there are significantly more runs than expected, and the
autocorrelations are not significant.
When we maximize or minimize the value of a decision variable by running several simulations
simultaneously, we have found an optimal solution to the problem and attitude toward risk
20 Total Points Multiple choice (2 Points each) Please highlight or clearly mark your responses
Expressed in percentiles, the interquartile range is the difference between the
a. 10th and 60th percentiles
b. 15th and 65th percentiles
c. 20th and 70th percentiles
d. 25th and 75th percentiles
e. 35th and 85th percentiles
Which of the following are considered measures of association?
a. Mean and variance
b. Variance and correlation
c. Correlation and covariance
d. Covariance and variance
e. First quartile and third quartile
If A and B are mutually exclusive events with P(A) = 0.70, then P(B):
a. can be any value between 0 and 1
b. can be any value between 0 and 0.70
c. cannot be larger than 0.30
d. Cannot be determined with the information given
Sampling error is evident when:
a. a question is poorly worded
b. the sample is too small
c. the sample is not random
d. the sample mean differs from the population mean
After calculating the sample size needed to estimate a population proportion to within 0.05, you have
been told that the maximum allowable error (B) must be reduced to just 0.025. If the original calculation
led to a sample size of 1000, the sample size will now have to be:
A multiple regression analysis including 50 data points and 5 independent variables results in
The multiple standard error of estimate will be:
In a random walk model the
a. series itself is random
b. series itself is not random but its differences are random
c. series itself and its differences are random
d. series itself and its differences are not random
When using exponential smoothing, if you want the forecast to react quickly to movements in the series,
you should choose:
a. values of
b. values of
c. values of
midway between 0 and 1
d. it depends on the data set
Consider the following linear programming problem:
The above linear programming problem:
has only one optimal solution
has more than one optimal solution
The expected value of perfect information (EVPI) is equal to:
a. EMV with posterior information EMV with prior information
b. EMV with free perfect information EMV with information
c. EMV with free perfect information EMV with no information
d. EMV with perfect information EMV with less than perfect information
Problem 3 (10 points)
Hunter Chemical Company claims that its major product contains on the average 4.0 fluid ounces of
caustic materials per gallon. It further states that the distribution of caustic materials per gallon is normal
and has a standard deviation of 1.3 fluid ounces.
What proportion of the individual gallon containers for this product will contain more than 5.0 fluid
ounces of caustic materials?
A government inspector randomly selects 100 gallon-size containers of the product and finds the
mean weight of caustic material to be 4.5 fluid ounces per gallon. What is the probability of finding
the mean of a sample of 100 that is 4.5 or greater? Do you think the production process was
producing its usual level of caustic materials when this sample was taken?
Problem 4 (10 points)
Southern Textiles wishes to predict employee wages by using the employees experience X 1 and the
employees education X2. Employees are categorized as having a college degree or not having a college
degree in their personnel files, so the variable education is a qualitative variable. Thus, X 2 is an
indicator (0, 1) variable. Data for the employees are given below:
Wages Y (Thousands
Education (College Degree
= 1, No College Degree =
(Economics for Management and Economics, Watson, Billingsley, Croft and Huntsberger, Fifth Edition,
1993, Page 685)
(a) Copy and paste the data from this document to an Excel file. Select Wages as the dependent variable
and experience and education as the independent variables. Conduct multiple regression using Excel.
Paste the output report below. Note: Follow the instructions given in module 5 to conduct simple
regression. At the step where you specify the input data range, instead of selecting the data for one
independent variable, select data for all the independent variables.
(b) Write the equation from the regression output report. If you are using symbols in the equation for the
variables, do define the symbols before using the symbols in the equation.
(c) Provide a clear and complete interpretation of the coefficients b 1 and b2 in the equation. There is no
need to interpret b0. Note: Use actual variable names and numbers in answering your question. b 1 and
b2 are slopes is not a sufficient answer.
(d) What is the value of R 2 for this model? Do you think that the model does a good job of explaining the
variation in wages? Why or why not?
(e) Set up the hypotheses to test whether the model is significant. Is the regression model significant at
0.05 as the level of significance? What does this mean?
(f) Set up the hypotheses to test for each of the regression coefficients individually and perform the test
at the 0.05 level of significance.
(g) What average wages do you predict for employees with college degrees and experience = 40 months?
Interpret your prediction.
Problem 5 (10 points)
The accompanying data are the times (in seconds) that it took a sample of employees to assemble a toy
truck at a Cole Industries assembly plant. Assembly times are normally distributed. At the 10% level, can
we conclude that the mean assembly time for this toy truck is not equal to 3 minutes? Use H a: µ 180
seconds as the alternative hypothesis.
Problem 6 (10 points)
The accompanying data indicate the number of mergers that took place in an industry over a 19-year
Fit a least squares trend line to the merger data.
b) What type of trend (linear or curved) might best fit to this time series?
Compute the forecast for year 20 based on the trend (linear or curved) that best fits the data?
Problem 7 (10 points)
Create another problem similar to Problem 3, 4, 5, or 6 and provide solutions as well.
Dear Student, Please find... View the full answer
- I want answer( If using R, please have input and output).Thanks!!
- I have one case project to ask for my economic 310 class which is statistic. All the requirements and instructions in the attached files. I need to turn it in
- Rating: Not yet rated
- Please, answer this assignment through excel. Thanks.
- Rating: Not yet rated
- Please make sure you answered all the questions completely. Thanks
- Rating: Not yet rated
- Final Project FP Requiremts= 2 pages This is your final project. You will prepare a PowerPoint presentation to present your findings. This assignment requires
- i do not know hot to generate data i uesd excal but i did not get the numberand the pictuer is not right. would you help me to solve this Q STEP BY STEP THANKS