Math 533 Applied Managerial Statistics Course Project

Math 533Applied Managerial StatisticsCourse ProjectYour instructor will provide you with a data file that includes data on five variables:SALES represents the number sales made this week.CALLS represents the number of sales calls made this week.TIME represents the average time per call this week.YEARS represents years of experience in the call center.TYPE represents the type of training the employee receivedPart C: Regression and Correlation Analysis:Use the dependent variable (labeled Y) and the independent variables (labeled X1, X2, and X3) in the data file. Use Excel to perform the regression and correlation analysis to answer the following.Generate a scatterplot for the specified dependent variable (Y) and the X1 independent variable, including the graph of the “best fit” line. Interpret.Determine the equation of the “best fit” line, which describes the relationship between the dependent variable and the selected independent variable.Determine the coefficient of correlation. Interpret.Determine the coefficient of determination. Interpret.Test the utility of this regression model. Interpret results, including the p-value.Based on the findings in Steps 1-5, analyze the ability of the independent variable to predict the designated dependent variable.Compute the confidence interval for ?1 (the population slope) using a 95% confidence level. Interpret this interval.Using an interval, estimate the average for the dependent variable for a selected value of the independent variable. Interpret this interval.Using an interval, predict the particular value of the dependent variable for a selected value of the independent variable. Interpret this interval.What can be said about the value of the dependent variable for values of the independent variable that are outside the range of the sample values? Explain.In an attempt to improve the model, use a multiple regression model to predict the dependent variable, Y, based on all of the independent variables, X1, X2, and X3.Using Excel, run the multiple regression analysis using the designated dependent and three independent variables. State the equation for this multiple regression model.Perform the Global Test for Utility (F-Test). Explain the conclusion.Perform the t-test on each independent variable. Explain the conclusions and clearly state how the analysis should proceed. In particular, which independent variables should be kept and which should be discarded. If any independent variables are to be discarded, re-run the multiple regression, including only the significant independent variables, and summarize results with discussion of analysis.Is this multiple regression model better than the linear model generated in parts 1-10? Explain.All DeVry University policies are in effect, including the plagiarism policy.Summarize your results from Steps 1–14 in a three-page report. The report should explain and interpret the results in ways that are understandable to someone who does not know statistics.Submission: The summary report and all of the work done in 1–14 (Excel output and interpretations) as an appendixFormat for report:Summary ReportPoints 1–14 should be addressed with appropriate output, graphs, and interpretations. Be sure to number each point 1–14.Sales (Y)48324447414632464233425042414144364738216745523733314444394342494140373646414942373721394449354643 Calls (X1)171139165186180184120172161143181148140198149168121149135185155149193159152170192165150174168178164191132140171170153154142130177160134131130183169 Time (X2)13.016.915.713.514.012.719.914.713.215.411.516.017.513.217.311.018.015.818.518.917.913.513.718.115.014.316.712.415.312.716.415.117.819.010.015.714.912.319.014.313.916.917.014.319.414.619.415.414.0 Years (X3)5433253313402205211211503413320335015032320451445 TypeONLINENONEONLINEONLINEONLINEONLINENONEGROUPGROUPNONEONLINENONEGROUPONLINEONLINEONLINENONEGROUPGROUPONLINENONEONLINEONLINENONEGROUPGROUPGROUPONLINEGROUPONLINEONLINEONLINEGROUPONLINENONENONEONLINEONLINEGROUPGROUPNONENONEONLINENONEGROUPGROUPNONEONLINEGROUP 4148394048504443333246485644344333495052454835444467514140454140474842412948334845364342495042444548 155182140157167144168175150155163162189153158160173178189184174188149159160166178178176138159145151186194152145188139201156131161152178157154156170170 16.013.012.415.414.815.812.413.614.917.916.614.515.015.314.210.917.518.314.311.413.613.615.614.614.818.916.513.412.615.318.814.716.614.213.614.519.011.319.312.513.218.517.314.616.415.915.320.014.217.4 22113225212432341214201221121222212422313231231015 ONLINEONLINENONEONLINEONLINENONEGROUPGROUPGROUPGROUPONLINEGROUPONLINEONLINEONLINEONLINEONLINEGROUPONLINEONLINEONLINEONLINEGROUPGROUPONLINEGROUPONLINEONLINEONLINENONEONLINENONEGROUPONLINEONLINEGROUPNONEONLINEGROUPONLINEGROUPNONEONLINEONLINEONLINEGROUPGROUPONLINEONLINEONLINE 39 144 17.7 3 NONE

Save Time On Research and Writing
Hire a Pro to Write You a 100% Plagiarism-Free Paper.
Get My Paper
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
The writer covered all points as expected by the professor. Thank you for your commitment to serve students.
Customer 452919, February 21st, 2024
Sociology
Thank you for answering all of the questions provided. The last 3 discussions, I only received a grade of 14 out of 20 points. Let's see how it goes after the grades are posted next week.
Customer 452919, February 9th, 2023
Nursing
Fabulous fast service
Customer 453075, April 21st, 2022
Social Work and Human Services
Thank you all for your assistance.
Customer 452919, March 22nd, 2025
Social Work and Human Services
Thank you for presenting the paper n-time. The team is getting much better. I have used you guys for a at least 4 semesters and will continue throughout my college career.
Customer 452919, February 21st, 2024
History
Thank you
Customer 452919, October 17th, 2024
Sociology
Thank you so much. Your Team is the greatest!
Customer 452919, May 3rd, 2022
Marketing
Thank you so much!
Customer 453015, December 13th, 2021
Psychology
Thank you very much! I will be using your service again soon.
Customer 452665, March 18th, 2021
Sociology
Thank you!
Customer 452919, April 5th, 2022
Advanced Technical Writing
Excellent service as always, Thank you!
Customer 452995, January 20th, 2022
Education
Very well written thank you
Customer 452667, April 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