02 Oct Case Analysis
38405it is a group project and I only have one part. I will post my part below this sentence. The one with (1=) Excel Analysis-Part I is my part and that’s what I want to be done.
Schedule:
Task Responsible Team Member Due Date
Schedule:
Task Responsible Team Member Due Date
1= Excel Analysis-Part I -Strength is forecasting/CH 7 7/3/2018
Excel Analysis Part II -Strength is Mann Whitney U Test/CH 9 7/3/2018
Double check data analysis -Strength is forecasting/analyzing 7/5/2018
/provide observations Part I
Double check data analysis -Strength is nonparametric analysis 7/5/2018
/provide observations Part II
Writing paper, finalizing, -Strength is writing papers 7/7/2018
and turning in
Excel Analysis Part II -Strength is Mann Whitney U Test/CH 9 7/3/2018
Double check data analysis -Strength is forecasting/analyzing 7/5/2018
/provide observations Part I
Double check data analysis -Strength is nonparametric analysis 7/5/2018
/provide observations Part II
Writing paper, finalizing, -Strength is writing papers 7/7/2018
and turning in
AND THIS IS THE ACTUAL PROJECT
All results need to be written in a professional report. Section each part off by titling the part and be sure to answer all questions thoroughly (not just numeric answers, explain your results).
Part I Public Enrollment in Colleges:
The data (first tab) in the Excel spreadsheet gives the enrollment (in millions) for public colleges from 1992 to 2016. NOTE: At the time the data was gathered, the data for 2017 was not available.
Using the time-series forecasting techniques, compute each of the following to then predict 2017:
Use a 3-year moving average
Use exponential smoothing with α=0.2 and let the forecast for 1993 equal the actual value for 1992.
Develop a linear regression model to fit the trend of the data.
Try a quadratic model.
In the techniques that you learned from forecasting and your results from the bulleted items above, determine which model fits the data best for future predicting. Explain thoroughly with calculated values, tables and graphs to support your findings.
Using the best model, make a prediction for the enrollment of 2017. What do your results tell you about public university enrollment?
Source: https://www.statista.com/statistics/183995/us-college-enrollment-and-projections-in-public-and-private-institutions/
Part 2 Male vs. Female Salaries:
The data (second tab) gives the salary of a sample taken from those that graduated college. The sample is separated by male vs. female. Does the male graduate earn significantly more than the female? As an analyst, us the Mann-Whitney U test to determine whether the male graduate earns significantly more than the female graduate for α=0.01. Explain thoroughly your findings.
Our website has a team of professional writers who can help you write any of your homework. They will write your papers from scratch. We also have a team of editors just to make sure all papers are of HIGH QUALITY & PLAGIARISM FREE. To make an Order you only need to click Ask A Question and we will direct you to our Order Page at WriteDemy. Then fill Our Order Form with all your assignment instructions. Select your deadline and pay for your paper. You will get it few hours before your set deadline.
Fill in all the assignment paper details that are required in the order form with the standard information being the page count, deadline, academic level and type of paper. It is advisable to have this information at hand so that you can quickly fill in the necessary information needed in the form for the essay writer to be immediately assigned to your writing project. Make payment for the custom essay order to enable us to assign a suitable writer to your order. Payments are made through Paypal on a secured billing page. Finally, sit back and relax.
About Wridemy
We are a professional paper writing website. If you have searched a question and bumped into our website just know you are in the right place to get help in your coursework. We offer HIGH QUALITY & PLAGIARISM FREE Papers.
How It Works
To make an Order you only need to click on “Order Now” and we will direct you to our Order Page. Fill Our Order Form with all your assignment instructions. Select your deadline and pay for your paper. You will get it few hours before your set deadline.
Are there Discounts?
All new clients are eligible for 20% off in their first Order. Our payment method is safe and secure.