Question

In: Statistics and Probability

USE EXCEL ONLY PLEASE! Do graduates of undergraduate business programs with different majors tend to earn...

USE EXCEL ONLY PLEASE!

Do graduates of undergraduate business programs with different majors tend to earn disparate average starting salaries? Is there any reason to doubt the equal variance assumption made in the one-way ANOVA model in this particular case? Support your response to this question.

Accounting Marketing Finance Management
$31,450 $28,350 $29,325 $27,320
$35,650 $27,845 $29,550 $26,450
$32,630 $28,430 $31,640 $30,135
$37,110 $27,645 $32,760 $27,340
$29,440 $28,635 $30,550 $28,635
$37,330 $29,875
$30,835 $28,890
$31,650

Solutions

Expert Solution

ANSWER;

Do graduates of undergraduate business programs with different majors tend to earn disparate average starting salaries? Consider the data listed .

a. Is there any reason to doubt the equal-variance assumption made in the one-way ANOVA model in this particular case? Support your response to this question.

In order to clear the doubt of the equal variance assumption made in On-Way ANOVA test in this particular case, Box plot can be made in Stat Tool using the following procedure as follows:

  1. 1. Consider the data as shown in the screenshot given below:

  2. 2. Select the whole data then go to Data Set Manager shown under the Stat Tools, and then a dialogue box will appear, Click Yes on it. Another dialogue box will appear, again click on Yes, in order to store this data on the Stat Tool.

    3. Then go to Summary Graph under Stat Tool, and under this select Box-Whisker Plot as shown in the screenshot given below:

  3. 4. Then the given below dialogue box will appear, in this tick all the 4 types of Business majors as shown below:

  4. 5. Click on OK in the above shown dialogue box, the output of the box-plot will be displayed o the new worksheet a shown below:

    From the side-by-side box plot obtained above two things are clear. First there is little doubt that students with Marketing major tend to have lowest starting salary than the students doing majoring in Management, Finance and Accounting. Secondly it can be clearly seen that the equal variance assumption is grossly violated here. There is very little variation in starting salary of studing doing majoring in Management and a large amount of variation in the starting salary of the stuents who are doing majoring in Accounting.

    In order to decide whether to reject the hypothesis that the mean starting salary is same for each of the given buiseness majors at 10 % significance level or not, following statistical test can be set up as follows:

    The Null Hypothesis will be that there is no difference in the mean starting salary for each of the given buiseness majors that is:

    Here is the mean starting salary of the business major. And the Alternative Hypothesis will be that there is significant difference in the mean starting salary for each of the Business major.

    To perform this test in Stat Tools following is the procedure:

    1 Consider the data as shown in the screenshot given below:

  5. 2. Select the whole data then go to Data Set Manager shown under the Stat Tools, and then a dialogue box will appear, Click Yes on it. Another dialogue box will appear, again click on Yes, in order to store this data on the Stat Tool.

    3. Then go to Statistical Inference and under this select One-way ANOVA as shown in the screenshot below:

  6. 4. The dialogue box which is shown below will appear, in this tick on all the 4 Categories of the Business majors and select 90% confidence interval from the drop down menu as shown below:

  7. 5. Click on OK in the above shown dialogue box, the One-Way ANOVA output will be displayed on the new worksheet as shown below:

    Thus by looking at the obtained above in the output summary of One-Way ANOAVA test, it can be said that there is evidence to reject the Null Hypothesis, because on comparing this value with 0.05, it is found that which is very less than 0.05, which is the condition for accepting the Alternative Hypothesis, so it can be

  8. rejected at 10 % significance levels that the mean starting salary is same for each of the given business majors

    In order to check which pairs of differences between the means are statistically significant at the 10 % confidence interval, first it is needed to construct 90% confidence intervals for all the pairs which can be done in Stat Tools as follows:

    In step 4 in the procedure explained in part b. the dialogue box which is shown below, tick on all the 4 business majors and under Confidence Interval Methods, tick on Turkey Correction and select 90% from the drop down menu under Confidence Interval as shown below:

  9. After Clicking on OK, the table of the confidence intervals which is shown below will appear in addition to the output summary which is obtained in part b.

    From the Confidence intervals of all the pair of differences between the means obtained above, it is observed that the pairs, Accounting-Marketing, Accounting-Finance, Accounting- management are statistically significantly at 10 % significance level because they are coming out to be all positive and thus with high confidence it can be said that the two means in the pair are not equal. Thus there is very strong evidence to reject the Null Hypothesis


Related Solutions

USE EXCEL ONLY PLEASE! Do graduates of undergraduate business programs with different majors tend to earn...
USE EXCEL ONLY PLEASE! Do graduates of undergraduate business programs with different majors tend to earn disparate average starting salaries? Is there any reason to doubt the equal variance assumption made in the one-way ANOVA model in this particular case? Support your response to this question. Accounting Marketing Finance Management $31,450 $28,350 $29,325 $27,320 $35,650 $27,845 $29,550 $26,450 $32,630 $28,430 $31,640 $30,135 $37,110 $27,645 $32,760 $27,340 $29,440 $28,635 $30,550 $28,635 $37,330 $29,875 $30,835 $28,890 $31,650
The proportion of business majors among college graduates in the US is 16%. Assume you select 27 college graduates at random.
The proportion of business majors among college graduates in the US is 16%. Assume you select 27 college graduates at random. 1st write the formula with factorials for the probability of getting 8 business majors:Compute the probability in the previous question:0.02930.97940.03470.01270.9873Compute the probability of getting 8 or less and 9 or more business majors:0.9653, 0.03470.9794, 0.02060.0347, 0.96530.9873, 0.01270.0206, 0.9794What are the expected value and standard deviation of this distribution? Which formulas to use?4.32, 1.905 F6d, F6e7.29, 1.776 F6d, F6e7.29, 1.776...
PLEASE DO NO USE EXCEL, as we are not able to use excel on our test...
PLEASE DO NO USE EXCEL, as we are not able to use excel on our test XYZ company is considering a new machine that costs $300,000 and would reduce pre-tax manufacturing costs by $108,000 annually. XYZ would use the 3-year MACRS method to depreciate the machine, and management thinks the machine would have a value of $23,000 at the end of its 5-year operating life. The applicable depreciation rates are 33%, 45%, 15%, and 7%. The net operating working capital...
Lisa wants to determine if graduates from her college earn different incomes compared to graduates from...
Lisa wants to determine if graduates from her college earn different incomes compared to graduates from college in general. To test this, Lisa sends surveys to 1,000 graduates from her school and finds that the average income is $40,000 ( s = 5,000). If the average income is $45,000 for graduates in general, do graduates from Lisa's school differ significantly? Report the results in APA style and be sure to include information about effect size.
Please answer in excel only. How do I create the graphs in excel and show the...
Please answer in excel only. How do I create the graphs in excel and show the data. Discuss the following two cost functions: TC=20+4Q TC=20+2Q+0.5Q^2 a) Calculate all cost curves and plot these curves on graphs. Total Cost Total Fixed Cost Total Variable Cost Average Total Cost Average Fixed Cost Average Variable Cost Marginal Cost b) In each case, indicate the point at which diminishing returns occur. (For question a), compute the required costs and plot the curves for quantities...
PLEASE DO NOT USE EXCEL, as we cannot use excel on our test. The Wagner Company...
PLEASE DO NOT USE EXCEL, as we cannot use excel on our test. The Wagner Company currently uses an injection-molding machine that was purchased 2 years ago. This machine is being depreciated on a straight-line basis, and it has 6-years of remaining life. Its current book value is $2,100, and it can be sold for $2,500 at this time. Thus, the annual depreciation expense is $350 [($2,100/6) = $350 per year]. If the old machine is not replaced, it can...
Please use ONLY one Excel file to complete this case study, and use one spreadsheet for...
Please use ONLY one Excel file to complete this case study, and use one spreadsheet for each problem. Develop a linear regression model to predict Wal-Mart revenue, using CPI as the only independent variable. Develop a linear regression model to predict Wal-Mart revenue, using Personal Consumption as the only independent variable. Develop a linear regression model to predict Wal-Mart revenue, using Retail Sales Index as the only independent variable. Which of these three models is the best?  Use R-square values, Significance...
Business Weekly conducted a survey of graduates from 30 top MBA programs. On the basis of...
Business Weekly conducted a survey of graduates from 30 top MBA programs. On the basis of the survey, assume the mean annual salary for graduates 10 years after graduation is 169000 dollars. Assume the standard deviation is 43000 dollars. Suppose you take a simple random sample of 77 graduates. Find the probability that a single randomly selected policy has a mean value between 168019.9 and 175860.4 dollars. P(168019.9 < X < 175860.4) = (Enter your answers as numbers accurate to...
Business Weekly conducted a survey of graduates from 30 top MBA programs. On the basis of...
Business Weekly conducted a survey of graduates from 30 top MBA programs. On the basis of the survey, assume the mean annual salary for graduates 10 years after graduation is 121000 dollars. Assume the standard deviation is 41000 dollars. Suppose you take a simple random sample of 79 graduates. Find the probability that a single randomly selected salary exceeds 117000 dollars. P(X > 117000) = Find the probability that a sample of size n=79 is randomly selected with a mean...
Business Weekly conducted a survey of graduates from 30 top MBA programs. On the basis of...
Business Weekly conducted a survey of graduates from 30 top MBA programs. On the basis of the survey, assume the mean annual salary for graduates 10 years after graduation is $156,000. Assume the standard deviation is $42,000. Suppose you take a simple random sample of 49 graduates. Round all answers to four decimal places if necessary. What is the distribution of XX? XX ~ N(,) What is the distribution of ¯xx¯? ¯xx¯ ~ N(,) For a single randomly selected graduate,...
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT