Question 1: The managing partner of an advertising agency

Question 1: The managing partner of an advertising agency believes that his company’s sales are related to the industry sales. He uses Microsoft Excel’s Data Analysis tool to analyze the last 4 years of quarterly data (i.e., n = 60) with the following results:Regression StatisticsMultiple R 0.946R Square 0.895Adjusted R Square 0.893Standard Error SYX 0.9995Observations 60ANOVA df SS MS F Sig.FRegression 1 493.988 493.988 494.466 0.000Error 58 57.944 0.999Total 59 551.932Predictor Coef StdError t Stat P-valueIntercept -7.7962 1.1549 -6.75 0.001Industry 7.8742 0.3541 22.2 0.000a) What is the value of the quantity that the least squares regression line minimizes? Explain your answer.b) What is the prediction of Y for a quarter in which X = 100? Show how you obtain your answer.c) What is the value for the coefficient of determination?d) What does the coefficient of determination tell you?Question 2: Your HR Director presents you the following data on your employees from a regression outputDependent variable: Wage and Salary Income (INCWS)Independent variable: a disability affecting work indicator————————————————————————————————– INCWS | Coefficient Std. Err. t P>|t| Beta————-+———————————————————————————— Work Disability | -9303.723 4475.500 -2.079 0.038 -0.070 constant | 37931.813 1416.073 26.787 0.000 ————————————————————————————————–Write the regression equation for the above output.What information does the constant give you?What information does the slope of the coefficient give you?Write the null and alternative hypotheses to test whether or not disabled people earn less than non-disabled people.At the 5% significance level, do disabled people earn less than non-disabled people?At the 1% significance level, do disabled people earn less than non-disabled people?Question 3: Given below is the Excel output from regressing GPA on ACT scores using a data set of 75 randomly chosen students from a Big-Ten university, with GPA on a 5-point grading scale.Regressing GPA on ACTRegression StatisticsMultiple R0.1027R Square0.0105Adjusted R Square-0.0030Standard Error9.8909Observations75ANOVAdfSSMSFSignificance FRegression176.12476.120.7780.3806Residual737141.5897.83Total747217.71CoefficientsStandard Errort StatP-valueLower 95%Upper 95%Intercept4.01333.8781.0350.3041-3.71511.742ACT0.09430.1070.8820.3806-0. 1190.307a) The interpretation of the coefficient of determination in this regression isA) 1.05% of the total variation of ACT scores can be explained by GPA.B) ACT scores account for 1.05% of the total fluctuation in GPA.C) GPA accounts for 1.05% of the variability of ACT scores.D) None of the above.b) What is the value of the measured test statistic to test whether there is any linear relationship between GPA and ACT? c) What is the predicted average value of GPA when ACT = 20? Show how you obtain your answer.d) What are the decision and conclusion on testing whether there is any linear relationship at 5% level of significance between GPA and ACT scores? Explain your answer.Question 4: Analysts at a major automobile company collected data on a variety of variables for a sample of 30 different cars and small trucks. Included among those data were the EPA highway mileage rating and the horsepower of each vehicle. The analysts were interested in the relationship between horsepower (x) and highway mileage (y). Given below is the Excel output from regressing starting miles per gallon (MPG) on number of horsepower for a sample of 30 students. Note: Some of the numbers in the output are purposely erased.Regression StatisticsMultiple R0.5493R Square0.3016Adjusted R Square0.2766Standard Error3.5532Observations30ANOVAdfSSMSFSignificance FRegression1152.65512.09112.091Residual12.625Total30506.167CoefficientsStandard Errort StatP-valueLower 95%Upper 95%Intercept31.16581.933216.120.000027.205835.1258Horsepower-0.02860.0082-3.47720.0017-0.0454-0.0117a) What is the estimated average change in MPG as a result of an extra unit of horsepower?b) What is the value of the measured t-test statistic and its p-value to test whether average MPG depends linearly on Horsepower?c) What is the error sum of squares (SSE) of the above regression? Show how you obtain your answer.f) The 99% confidence interval for the average change in MPG as a result of increased horsepower is:A) wider than [-0.0454, -0.0117].B) narrower than [-0.0454, -0.0117].C) wider than [27.2058, 35.1258].D) narrower than [27.2058, 35.1258].Explain your reasoning.Question 5: A shipping company believes that the variation in the cost of a customer’s shipment can be explained by differences in the weight of the package being shipped. To investigate whether this relationship is useful, a random sample of 20 customer shipments was selected, and the weight (in lb.) and the cost (in dollars, rounded) for each shipment were recorded. The following results were obtained:Weight (lbs.)Cost (Dollars)81168511711121791117271316891825172117241016202492151013216166111220a) Construct a scatter plot for these data. What, if any, relationship appears to exist between the two variables?b) Compute the linear regression model based on the sample data. Interpret the slope and regression coefficients.c) Test the significance of the overall regression model using a significance level of 0.05.d) What percentage of the total variation in shipping cost can be explained by the regression model you developed in part b?

Calculate the price
Make an order in advance and get the best price
Pages (550 words)
$0.00
*Price with a welcome 15% discount applied.
Pro tip: If you want to save more money and pay the lowest price, you need to set a more extended deadline.
We know how difficult it is to be a student these days. That's why our prices are one of the most affordable on the market, and there are no hidden fees.

Instead, we offer bonuses, discounts, and free services to make your experience outstanding.
How it works
Receive a 100% original paper that will pass Turnitin from a top essay writing service
step 1
Upload your instructions
Fill out the order form and provide paper details. You can even attach screenshots or add additional instructions later. If something is not clear or missing, the writer will contact you for clarification.
Pro service tips
How to get the most out of your experience with Essay Fountain
One writer throughout the entire course
If you like the writer, you can hire them again. Just copy & paste their ID on the order form ("Preferred Writer's ID" field). This way, your vocabulary will be uniform, and the writer will be aware of your needs.
The same paper from different writers
You can order essay or any other work from two different writers to choose the best one or give another version to a friend. This can be done through the add-on "Same paper from another writer."
Copy of sources used by the writer
Our college essay writers work with ScienceDirect and other databases. They can send you articles or materials used in PDF or through screenshots. Just tick the "Copy of sources" field on the order form.
Testimonials
See why 20k+ students have chosen us as their sole writing assistance provider
Check out the latest reviews and opinions submitted by real customers worldwide and make an informed decision.
Sociology
I want to thank the entire team. Please know that I am truly grateful for your service.
Customer 452919, November 11th, 2021
Sociology
Thank you so much. Your Team is the greatest!
Customer 452919, May 3rd, 2022
Sociology
I have never experienced receiving a paper past the due date and time. That is the only thing that displeases. I don't have time o Overall, your team does a great job.
Customer 452919, November 18th, 2021
Nursing
The second attempt was an unplagiarized paper. Thank you
Customer 452545, September 25th, 2020
Computer science
Thank You
Customer 453099, August 28th, 2022
Economics
Satisfactory
Customer 452963, November 11th, 2021
Psychology
Paper was received before time which I was quite please with.
Customer 453101, June 18th, 2022
Sociology
Thank you
Customer 452919, March 23rd, 2022
Sociology
Thank you
Customer 452919, February 16th, 2024
History
Thank you for the revision
Customer 452919, October 31st, 2024
Sociology
Thank you Team!
Customer 452919, April 5th, 2022
Sociology
Thanks to the entire team!
Customer 452919, December 8th, 2021
11,595
Customer reviews in total
96%
Current satisfaction rate
3 pages
Average paper length
37%
Customers referred by a friend
OUR GIFT TO YOU
15% OFF your first order
Use a coupon FIRST15 and enjoy expert help with any task at the most affordable price.
Claim my 15% OFF Order in Chat