'Group Assignment 1\r'

'Managerial Statistics (ENMGT 572) Group Assignment You are permitted to mapping SPSS to solve the quest problems unless otherwise stated. Problem 1: Refer to the data point Executive lucre. xls. This files shows yearbook salary of CEOs for various companies and industries. The random variable of have-to doe with for this exercise is Sum97. This is the CEO’s annual salary plus bonuses for the year 1997 (referred to as salary here-in).The social occasion of this exercise is to determine if at that place is a evidentiary deviation between rigorous salaries of executives for various industries. thither are 8 industries in this data file. set the following questions, assume = . 05 level for all(a) stresss. a. curtly explain (in one or 2 sentences) what geek of interrogation approach you would use to determine if in that respect is a exit in the mean salaries among all industries. Also, how would you set up the null and alternate hypothesis? b. Conduct a test to determine if the mean salaries among all industries are equivalent.Also, if on that point is a difference briefly explain or identify the variables or categories (treatment) that contribute to this difference (You may use Tukey’s Procedure for answering this part) c. Conduct a test to determine if there exist a difference in the mean executive salary for the following groups of industries: I. Industrial and raw material Materials II. Industrial and Technology III. Basic Materials and Technology Before conducting the test above, perform a test on equivalent population variances for to each one(prenominal) pair of company character reference.In a brief paragraph, gab of the conclusions of the test results. d. Determine the upper and lower cast off salary values for each industry at 90% and 95% confidence intervals e. Perform a test of normality (Chi-Square evaluation) on the data for each of the three industries in part c and gossipmonger on your findings. First produ ce a histogram with to the highest degree 5 categories for this test and perform the test victimisation a Chi-Squared approach. Problem 2: Refer to file â€Å"Heating_Bill. xls,” which provides oestrus bills on a sample of residential homes for the month of February.The file categorizes the data by the type of home (single level or two story) and oestrus line of descent (natural gas, electric and oil). Conduct a test at the =. 05 level to answer the following questions: a. Is there evidence to suggest that the type of heating source used impacts the monthly heating bill? b. Is there evidence to suggest that the type of home (single or two story) impacts the monthly heating bill? c. Is there evidence to suggest that the interaction between these two categories (type of home or heating source) impacts the monthly heating bill?\r\n'