Question
1. In the file MajorSalary.xlsx , data have been collected from 111 College of Business graduates on their monthly starting salaries. The graduates include students
1. In the file MajorSalary.xlsx, data have been collected from 111 College of Business graduates on their monthly starting salaries. The graduates include students majoring in management, finance, accounting, info systems, and marketing. Create a PivotTable in Excel to display the number of graduates in each major and the average monthly starting salary for students in each major.
a. Which major has the most graduates?
b. Which major has the highest average starting monthly salary?
c. Use the PivotTable to determine the major of the student with the lowest overall starting salary?
2. In the file Jensen.xlsx, Jensen auto is deciding whether to purchase a new maintenance contract for its new computer wheel alignment and balancing machine. The data in the file shows the relationship between usage and annual expense.
a. Develop a scatter chart with usage as the independent variable.
b. Use the data to develop a regression equation that could be used to predict the annual maintenance expense for a given numbers of hours of weekly usage. What is the model?
c. How much of the variation in the sample values of annual maintenance does the model you estimate in part b explain (Hint: Use r squared to explain).
Major salary excel document with all info needed!
| Major | Monthy Salary |
| Management | 3330 |
| Management | 2700 |
| Finance | 3155 |
| Accounting | 3855 |
| Info Systems | 4220 |
| Accounting | 3110 |
| Accounting | 3880 |
| Management | 3695 |
| Finance | 3775 |
| Finance | 3875 |
| Accounting | 4560 |
| Accounting | 3475 |
| Marketing | 2780 |
| Marketing | 3715 |
| Marketing | 3260 |
| Management | 3175 |
| Finance | 3355 |
| Accounting | 4205 |
| Finance | 4000 |
| Finance | 4245 |
| Finance | 2950 |
| Marketing | 3270 |
| Management | 3835 |
| Accounting | 4150 |
| Marketing | 3200 |
| Accounting | 3140 |
| Finance | 3700 |
| Marketing | 3480 |
| Accounting | 3760 |
| Marketing | 3440 |
| Marketing | 3535 |
| Management | 2630 |
| Accounting | 4280 |
| Management | 4285 |
| Accounting | 3240 |
| Marketing | 3115 |
| Marketing | 3645 |
| Accounting | 3800 |
| Marketing | 3635 |
| Accounting | 4890 |
| Info Systems | 3855 |
| Marketing | 3110 |
| Finance | 2955 |
| Management | 3440 |
| Marketing | 3935 |
| Info Systems | 4360 |
| Info Systems | 4285 |
| Marketing | 2495 |
| Management | 2800 |
| Marketing | 4485 |
| Management | 2840 |
| Management | 3135 |
| Marketing | 3190 |
| Marketing | 3190 |
| Management | 2240 |
| Accounting | 3780 |
| Management | 2975 |
| Management | 3275 |
| Marketing | 3645 |
| Management | 3250 |
| Finance | 3875 |
| Marketing | 2900 |
| Management | 2685 |
| Accounting | 3020 |
| Info Systems | 4410 |
| Finance | 3350 |
| Accounting | 5000 |
| Accounting | 4040 |
| Accounting | 3770 |
| Accounting | 4995 |
| Info Systems | 5030 |
| Finance | 3370 |
| Accounting | 4340 |
| Accounting | 4225 |
| Finance | 3400 |
| Management | 2890 |
| Finance | 4075 |
| Finance | 3530 |
| Info Systems | 3325 |
| Marketing | 3025 |
| Marketing | 4010 |
| Management | 2865 |
| Management | 4245 |
| Accounting | 5650 |
| Accounting | 4090 |
| Info Systems | 3715 |
| Accounting | 3800 |
| Management | 3365 |
| Accounting | 3095 |
| Info Systems | 3765 |
| Info Systems | 3860 |
| Accounting | 2700 |
| Finance | 5000 |
| Info Systems | 4610 |
| Accounting | 5500 |
| Info Systems | 3610 |
| Info Systems | 3865 |
| Accounting | 4210 |
| Management | 3190 |
| Finance | 3810 |
| Finance | 4175 |
| Finance | 3535 |
| Management | 2780 |
| Info Systems | 3965 |
| Finance | 3665 |
| Info Systems | 4295 |
| Management | 3080 |
| Management | 3615 |
| Finance | 3800 |
| Info Systems | 2830 |
| Marketing | 2530 |
Jensen excel document with all info needed!
| Weekly Usage (hours) | Annual Maintenance Expense |
| 13 | 17.0 |
| 10 | 22.0 |
| 20 | 30.0 |
| 28 | 37.0 |
| 32 | 47.0 |
| 17 | 30.5 |
| 24 | 32.5 |
| 31 | 39.0 |
| 40 | 51.5 |
| 38 | 40.0 |
Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started
Fundamentals Of Corporate Finance
Authors: Richard A. Brealey, Marcus, Alan J, Myers, Stewart C.
2nd Edition
0070074860, 9780070074866
