I need the work shown on all assignments and done in excel. Please look through each week and look at
the time frames. I fell behind and am trying to catch up. There cannot be any plagiarism in the written
answers. ROI Questions are related to attached excel sheet.
Week 3 Project Need in 2 days
Using the ROI data set: See excel sheet
If we select 7 colleges from a major and then record whether they are of ‘School Type’ ‘Private’ or not, is
this experiment a binomial one? Why or why not?
For each of the 2 majors determine if the ‘Annual % ROI’ appears to be normally distributed. Consider
the shape of the histogram and the measures of central tendency (mean and median) to justify your
results. Report on each of these with charts and calculations to justify your answers.
Week 4 (Need in 4 days)
Question 1
The following shows the temperatures (high, low) and weather conditions in a given Sunday for some
selected world cities. For the weather conditions, the following notations are used: c = clear; cl = cloudy;
sh = showers; pc = partly cloudy.
How many elements are in this data set?
How many variables are in this data set?
How many observations are in this data set?
Name the variables and indicate whether they are categorical or quantitative.
Question 2
A student has completed 20 courses in the School of Arts and Sciences. Her grades in the 20 courses are
shown below.
Develop a frequency distribution and a bar chart for her grades.
Develop a relative frequency distribution for her grades and construct a pie chart.
Question 3
The number of hours worked per week for a sample of ten students is shown below.
Determine the median and explain its meaning.
Compute the 70th percentile and explain its meaning.
What is the mode of the above data? What does it signify?
Question 4
You are given the following information on Events A, B, C, and D.
Compute P(D).
Compute P(A ∩ B).
Compute P(A | C).
Compute the probability of the complement of C.
Are A and B mutually exclusive? Explain your answer.
Are A and B independent? Explain your answer.
Are A and C mutually exclusive? Explain your answer.
Are A and C independent? Explain your answer.
Question 5
When a particular machine is functioning properly, 80% of the items produced are non-defective.
If three items are examined, what is the probability that one is defective?
Use the binomial probability function to answer this question.
Question 6
The average starting salary of this year’s graduates of a large university (LU) is $20,000 with a standard
deviation of $8,000. Furthermore, it is known that the starting salaries are normally distributed.
What is the probability that a randomly selected LU graduate will have a starting salary of at least
$30,400?
Individuals with starting salaries of less than $15,600 receive a low income tax break. What percentage
of the graduates will receive the tax break?
What are the minimum and the maximum starting salaries of the middle 95.4% of the LU graduates?
Question 7
A simple random sample of 6 computer programmers in Houston, Texas revealed the sex of the
programmers and the following information about their weekly incomes.
What is the point estimate for the average weekly income of all the computer programmers in Houston?
What is the point estimate for the standard deviation of the population?
Determine a point estimate for the proportion of all programmers in Houston who are female.
Question 8
Students of a large university spend an average of $5 a day on lunch. The standard deviation of the
expenditure is $3. A simple random sample of 36 students is taken.
What are the expected value, standard deviation, and shape of the sampling distribution of the sample
mean?
What is the probability that the sample mean will be at least $4?
What is the probability that the sample mean will be at least $5.90?
Week 5 (Need in 6-7 days)
In a poll of 600 voters in a campaign to eliminate non-returnable beverage containers,
210 of the voters were opposed. Develop a 92% confidence interval estimate for the
proportion of all the voters who opposed the container control bill.
A random sample of 87 airline pilots had an average yearly income of $99,400 with a
standard deviation of $12,000.
1. If we want to determine a 95% confidence interval for the average yearly income, what
is the value of t?
2. Develop a 95% confidence interval for the average yearly income of all pilots.
In order to determine the average weight of carry-on luggage by passengers in
airplanes, a sample of 25 pieces of carry-on luggage was collected and weighed. The
average weight was 18 pounds. Assume that we know the standard deviation of the
population to be 7.5 pounds.
1. Determine a 97% confidence interval estimate for the mean weight of the carry-on
luggage.
2. Determine a 95% confidence interval estimate for the mean weight of the carry-on
luggage.
A statistician employed by a consumer testing organization reports that at 95%
confidence he has determined that the true average content of the Uncola soft drinks is
between 11.7 to 12.3 ounces. He further reports that his sample revealed an average
content of 12 ounces, but he forgot to report the size of the sample he had selected.
Assuming the standard deviation of the population is 1.28, determine the size of the
sample.
Week 5 Project (6-7 Days)
Using the ROI data set: See excel sheet
1. For each of the 2 majors consider the ‘School Type’ column. Assuming the
requirements are met, construct a 90% confidence interval for the proportion of the
schools that are ‘Private’. Be sure to interpret your results.
2. For each of the 2 majors construct a 95% confidence interval for the mean of the
column ‘Annual % ROI’. Be sure to interpret your results.
Week 6 Assignment (By May 27)
Question 1
A sample of 81 account balances of a credit company showed an average balance of
$1,200 with a standard deviation of $126.
1. Formulate the hypotheses that can be used to determine whether the mean of all
account balances is significantly different from $1,150.
2. Compute the test statistic.
3. Using the p-value approach, what is your conclusion? Let α = .05.
Question 2
During the recent primary elections, the democratic presidential candidate showed the
following pre-election voter support in Alabama and Mississippi.
1. We want to determine whether or not the proportions of voters favoring the Democratic
candidate were the same in both states. Provide the hypotheses.
2. Compute the test statistic.
3. Determine the p-value; and at 95% confidence, test the above hypotheses.
Question 3
In order to estimate the difference between the yearly incomes of marketing managers
in the East and West of the United States, the following information was gathered.
1. Develop an interval estimate for the difference between the average yearly incomes of
the marketing managers in the East and West. Use α = 0.05.
2. At 95% confidence, use the p-value approach and test to determine if the average
yearly income of marketing managers in the East is significantly different from the
West.
Week 6 Project (By May 27th)
Using the ROI data set: See excel sheet
1. For each of the 2 majors test the hypothesis at the 5% significance level:
o The mean ‘Cost’ for a college is $160,000. Be sure to interpret your results.
2. For Business versus Engineering majors conduct a two sample test of the hypothesis at
the 10% significance level (assume the variances are not equal):
o The average ’30-Year ROI’ for Business majors is less than for Engineering Majors. Be
sure to interpret your results.
Week 7 Assignment (Need by May 27th)
Question 1
Assume you have noted the following prices for paperback books and the number of
pages that each book contains.
Develop a least-squares estimated regression line.
1. Compute the coefficient of determination and explain its meaning.
2. Compute the correlation coefficient between the price and the number of pages. Test to
see if x and y are related. Use α = 0.10.
Question 2
The following data represent a company's yearly sales volume and its advertising
expenditure over a period of 8 years.
1. Develop a scatter diagram of sales versus advertising and explain what it shows
regarding the relationship between sales and advertising.
2. Use the method of least squares to compute an estimated regression line between sales
and advertising.
3. If the company's advertising expenditure is $400,000, what are the predicted sales?
Give the answer in dollars.
4. What does the slope of the estimated regression line indicate?
Week 7 Project (need by May 27th)
Using the ROI data set: See excel sheet
For each of the two majors:
1. Draw the scatter diagram of Y = ‘Annual % ROI’ against X = ‘Cost’.
2. Obtain b0 and b1 of the regression equation defined as y ̂ = b0 + b1X and the
coefficient of determination (r2) from the Excel regression output.
3. Draw the fitted regression line on the scatter diagram.
4. Calculate the estimated ‘Annual % ROI’ when the ‘Cost’ (X) is $160,000.
5. Test the hypothesis:
o H0: β1 = 0
o Ha: β1 ≠ 0
6. Write a paragraph or more on any observations you make about the regression
estimates, coefficient of determination, the plots, and the results of your hypothesis
tests.
Week 8 (Need by May 30th)
Write a minimum 4 page report explaining the results from your analysis of the ROI of
Business Majors and Engineering Majors. Use your results from each week’s assignment
to make this report.
This report should include:
A detailed description of the data used in this analysis – specifically explain what the
data in each column represents.
o
o
o
o
A detailed explanation of any information learned about:
School Type for each major;
The Cost for each major;
The 30 Year ROI for each major;
The Annual % ROI for each major.
Explanations should be supported with the results obtained from your work in previous
weeks.
o
o
Finally, answer the following questions and support your answer with your results.
Does there appear to be a particular major that gives a better ROI? Why or Why not?
Given that we are using statistical inference to make our conclusions, is it guaranteed
that the major you choose that gave a better ROI for this sample will always have a
better ROI than the other major? Explain your reasoning
School Type
Private
Private
Private
Public
Private
Public
Private
Private
Private
Private
Private
Private
Private
Private
Private
Public
Public
Private
Private
Private
Best College ROI by Majo 2013: Payscale.com
Cost
$222,700.00
$176,400.00
$212,200.00
$125,100.00
$212,700.00
$92,910.00
$214,900.00
$217,800.00
$225,600.00
$217,300.00
$226,500.00
$215,500.00
$223,500.00
$226,600.00
$189,300.00
$89,700.00
$87,030.00
$218,200.00
$229,900.00
$148,800.00
30 Year ROI
$1,786,000.00
$1,758,000.00
$1,714,000.00
$1,535,000.00
$1,529,000.00
$1,501,000.00
$1,485,000.00
$1,483,000.00
$1,444,000.00
$1,442,000.00
$1,441,000.00
$1,438,000.00
$1,428,000.00
$1,414,000.00
$1,397,000.00
$1,382,000.00
$1,376,000.00
$1,343,000.00
$1,339,000.00
$1,321,000.00
Annual ROI
7.70%
8.40%
7.80%
9.10%
7.40%
10.10%
7.30%
7.20%
7.00%
7.10%
7.00%
7.20%
7.00%
7.00%
7.50%
9.90%
10.00%
6.90%
6.70%
8.10%
School Type
Private
Private
Private
Private
Private
Public
Private
Private
Public
Private
Public
Private
Public
Private
Public
Public
Public
Public
Private
Public
Cost
$221,700.00
$213,000.00
$230,100.00
$222,600.00
$225,800.00
$87,660.00
$224,900.00
$221,600.00
$125,100.00
$215,700.00
$92,530.00
$217,800.00
$89,700.00
$229,600.00
$101,500.00
$115,500.00
$104,500.00
$69,980.00
$219,400.00
$64,930.00
30 Year ROI
Annual ROI
$2,412,000.00
8.70%
$2,064,000.00
8.30%
$1,949,000.00
7.90%
$1,947,000.00
8.00%
$1,938,000.00
8.00%
$1,937,000.00
11.20%
$1,915,000.00
7.90%
$1,878,000.00
7.90%
$1,854,000.00
9.80%
$1,794,000.00
7.90%
$1,761,000.00
10.60%
$1,752,000.00
7.70%
$1,727,000.00
10.70%
$1,716,000.00
7.50%
$1,703,000.00
10.20%
$1,694,000.00
9.70%
$1,690,000.00
10.10%
$1,685,000.00
11.50%
$1,676,000.00
7.60%
$1,668,000.00
11.70%
...

Purchase answer to see full
attachment