Reference no: EM133104697
BBA1033 Business Statistics - Malaysia University of Science and Technology
Question 1: The Excel file Unions and Labor Law Data reports the percentage of public- and private-sector employees in unions in 2020 for each state, along with indicators whether the states had a bargaining law that covered public employees or right-to-work laws.
a. Develop and test the hypothesis that the percentage of employees in unions for both the public sector and private sector is the same for states having bargaining laws as for those who do not.
b. Test the hypothesis that the percentage of employees in unions for both the public sector and private sector is the same for states having right-to-work laws as for those who do not.
Questions 2:
The Excel file Salary Data provides information on current salary, beginning salary, previous experience (in months) when hired, and total years of education for a sample of 100 employees in a firm.
a. Develop a multiple regression model for predicting current salary as a function of the other variables. Hint: You are required to include the full result as part of your report.
b. What is estimated salary for a person with the following background:
- Beginning Salary: $ 28500
- Previous Experience (months): 65months
- Education (years): 17 years
c. Interprate if the developed model is significant
d. State the suitable hypostases Hypotheses.
e. Interpret the R2
f. Find the best model for predicting current salary using the p-value criterion. Hint: You are required to report the result for each stated hypothesis based on the results.
g. Based on these results, what would be your piece of advice for a job seeker?
Attachment:- Business Statistics.rar
Attachment:- Data_Set.rar