MGT 314
Project 2
MGT 314代写 Problem 1. Alumni Giving：Alumni donations are an important source of revenue for colleges and universities. If administrators could
Problem 1. Alumni Giving MGT 314代写
Alumni donations are an important source of revenue for colleges and universities. If administrators could determine the factors that could lead to increases in the percentage of alumni who make a donation, they might be able to implement policies that could lead to increased revenues. Research shows that students who are more satisfied with their contact with teachers are more likely to graduate. As a result, one might suspect that smaller class sizes and lower student/faculty ratios might lead to a higher percentage of satisfied graduates, which in turn might lead to increases in the percentage of alumni who make a donation. MGT 314代写
The following table shows data for 48 national universities. The Graduation Rate column is the percentage of students who initially enrolled at the university and graduated. The % of Classes Under 20 column shows the percentages of classes with fewer than 20 students that are offered. The Student/Faculty Ratio column is the number of students enrolled divided by the total number of faculty. Finally, the Alumni Giving Rate column is the percentage of alumni who made a donation to the university.
Use the AlumniGiving data file for this analysis. Below is a snapshot of the AlumniGiving data file.
Managerial Report MGT 314代写
1.Use methods of descriptive statistics to summarize the data. (Mean, median, standard deviation, percentiles, etc.)
2.Using Excel, get the correlation between alumni giving rate and other numeric variables. Which variable has the largest correlation with alumni giving rate.
3.Develop an estimated simple linear regression model that can be used to predict the alumni giving rate, given the graduation rate. Draw a scatter plot using these two variables. Discuss your findings.
4.Develop an estimated multiple linear regression model that could be used to predict the alumni giving rate using Graduation Rate, % of Classes Under 20, and Student/Faculty Ratioas independent variables. Discuss your findings.
5.Based on the results in parts (3) and (4), do you believe another regression model may be more appropriate? Estimate this model and discuss your results. MGT 314代写
6.What conclusions and recommendations can you derive from your analysis? What universities are achieving a substantially higher alumni giving rate than would be expected, given their Graduation Rate, % of Classes Under 20, and Student/Faculty Ratio? What universities are achieving a substantially lower alumni giving rate than would be expected, given their Graduation Rate, % of Classes Under 20, and Student/Faculty Ratio?
7.Perform clustering in Tableau using different variables. Use 2 or 3 clusters. Choose 1 or 2 plots and include it in your report. Include the screenshot that shows both the figure and the variables used in the plots. Write which variables were used in creating the clusters. Include the cluster description table. What does the clustering tell you?
8.What other independent variables could be included in the regression model? What other variables can you think of that could be useful in predicting whether a graduate would donate to the university or not?
Problem 2: Promotional Budgeting. MGT 314代写
The Westchester Chamber of Commerce periodically sponsors public service seminars and programs. Currently, promotional plans are under way for this year’s program. Advertising alternatives include television, radio, and online. Audience estimates, costs, and maximum media usage limitations are as shown:
To ensure a balanced use of advertising media, radio advertisements must not exceed 50% of the total number of advertisements authorized. In addition, television should account for at least 10% of the total number of advertisements authorized.
1.If the promotional budget is limited to $18,200, how many commercial messages should be run on each medium to maximize total audience contact? What is the allocation of the budget among the three media, and what is the total audience reached?
2.By how much would audience contact increase if an extra $100 were allocated to the promotional budget?
Deliverables:
In both questions write your answers in Word Doc.
Include the Excel solution files.
Submit both the Word and Excel files.
其他代写：project代写 essay作业代写 finance代写 python代写 homework代写 java代写 matlab代写 program代写 essay代写 report代写 paper代写 assignment代写 加拿大代写 作业代写 作业加急 北美代写 英国代写 北美作业代写
合作平台：essay代写 论文代写 写手招聘 英国留学生代写
