Reference no: EM133119028
ADMN 2606 Business Statistics - Nipissing University
Aiming to better understand the differences between salaries of graduates, Nipissing University has collected data from a sample 186 members of our alumni. The data include salary of Marketing, HR and Accounting graduates based on years of experience upon graduation from the School of Business.
The data reflects:
• Starting salary of our graduates in Marketing, HR and Accounting
• GPA of Accounting students
• Whether Marketing students took part in the coop program (No=0 and yes=1)
• Years of work experience upon graduation for all the streams
* Assume the collected data has normal distribution
Nipissing University would like to know the following based on the collected data.
1. Conduct a descriptive analysis of the sample focusing on Accounting Students (GPA, Years of Experience and Salary) report on measures of central location and variance for two different variables, also use a graph to describe one of the variables.
2. Is there a relationship between GPA and Salary for Accounting students, use a graph to depict this relationship and conduct correlation analysis
3. Can Nipissing University infer significant differences exist between salary of their marketing and HR graduates.
4. Estimate the mean salary of HR students with 95% confidence.
5. Estimate with 95% confidence the portion of marketing students that took part in coop (code 1 from the dataset).
6. Can we infer there are any significant differences in graduate salaries (Accounting, Marketing and HR) based on years of experience (30%)?
• Assume significance level of .05 when needed. Directions:
- Answer each question on a separate Excel Sheet using Data Analysis and Data Analysis Plus or XLSTAT.
- Each excel sheet should include the following:
• Analysis: 1) State your chosen method of analysis; 2) present the test results in tables (Make sure to present the complete and relevant Excel output (Table) for each of the questions). Note: If the question involves hypothesis testing present the null and alternative hypothesis.
• Discussion: For each question briefly discus the findings of the study, what do they mean? how can they aide in decision making?
Attachment:- Business Statistics.rar
|
Prepare the journal entry to account for the change
: No depreciation has been provided in the current period. Prepare the journal entry to account for the change in the accounting estimate
|
|
Expected rate of return of menger corporation
: Menger Corporation has a 0.4 probability of a return of 0.37, a 0.3 probability of a rate of return of 0.05, and the remaining probability of a -0.20 rate of re
|
|
Four swap strategies
: 1) For the four swap strategies listed below, which would you enter into if you thought floating rates were going to increase by more than market expectations?
|
|
What would be the amount of sales dollars
: Wallace, Inc., prepared the following budgeted data based on a sales forecast of $6,000,000: What would be the amount of sales dollars at the break-even point
|
|
ADMN 2606 Business Statistics Assignment
: ADMN 2606 Business Statistics Assignment Help and Solution, Nipissing University - Assessment Writing Service - understand the differences between salaries
|
|
Compute the duration and modified duration
: Compute the duration and modified duration of a 6 year bond that makes annual payments with a coupon rate of 9% and a YTM of 7%.
|
|
Difference between accrual and cash-basis accounting
: Explain the difference between accrual and cash-basis accounting as if you were talking to your mom (or another person that you have a deep, personal relationsh
|
|
What is the value of a similar 10-year bond
: What is the value of a 1-year, $1,000 par value bond with a 10% annual coupon if its required rate of return is 10%? What is the value of a similar 10-year bond
|
|
What will the outcome be for operating income
: The variable cost per unit increases by 15%, and all other factors remain the same, what will the outcome be for operating income
|