Business Statistics excel spreadsheet, Assignment Homework Help

Anonymous
timer Asked: May 17th, 2016
account_balance_wallet $9.99

Question Description

This is half of week 3 and weeks 4-8. Please look at due dates on Word doc spread sheet labeled Statistics3-8 and the projects refer to the excel spreadsheet which I have attached. No plagiarism with written questions please. 

Unformatted Attachment Preview

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

Tutor Answer

pallveechem123
School: UC Berkeley

Final report work Q-8 submitted.Pallvee

Report
It is of utmost significance for students to choose major in college career. Apart from interest,
there are other parameters worth considering before taking decision about major in college
career. Of them, two are cost of the degree and return of investment (ROI).Generally, return of
investment (ROI) in performance metric that can be applied to purchases to weigh up as to
whether something is worth one’s cost. In terms of education, ROI measures graduate’s future
earnings (return) against cost of attending college (investment). It is important for student to
determine major’s ROI before making any commitments. Data given to analysis is for two
majors, i.e. engineering major and business major. For each major, first column refers to types of
college, viz. private or public, second column referring cost of attending the major, third
referring graduate’s earnings in 30 years, and fourth referring annual ROI.

School Type for each major
There are two types of school, i.e. private and public. A public school is a college primarily
funde...

flag Report DMCA
Review

Anonymous
Tutor went the extra mile to help me with this essay. Citations were a bit shaky but I appreciated how well he handled APA styles and how ok he was to change them even though I didnt specify. Got a B+ which is believable and acceptable.

Brown University





1271 Tutors

California Institute of Technology




2131 Tutors

Carnegie Mellon University




982 Tutors

Columbia University





1256 Tutors

Dartmouth University





2113 Tutors

Emory University





2279 Tutors

Harvard University





599 Tutors

Massachusetts Institute of Technology



2319 Tutors

New York University





1645 Tutors

Notre Dam University





1911 Tutors

Oklahoma University





2122 Tutors

Pennsylvania State University





932 Tutors

Princeton University





1211 Tutors

Stanford University





983 Tutors

University of California





1282 Tutors

Oxford University





123 Tutors

Yale University





2325 Tutors