As companies gradually moving out of recession caused by the Covid-19 pandemic, there was an increased attention to productivity. In that spirit, Mr Zhang Tianhan, the Operations Director of a textile manufacturing company, wants to determine what are the factors that could affect productivity. The factory is organised in teams of 10 workers hence all measurements are team-based. He collected the following data for this purpose:

TEAM:

Team 1 to 20

PRODUCTION:

Production volume for each team (units per day)

EXPERIENCE:

Average sewing experience in each team (years)

AGE:

Average age of workers in each team (years)

SHIFT:

1 means day-shift

0 means night-shift

GENDER:

1 means team leader is male

0 means team leader is female

The dataset can be found in the below. The production is the dependent variable and the other variables are independent variables.

(a)Describe the relationship between production and the four (4) independent variables by writing down the linear equation. Interpret the coefficients to show how each of the independent variables impact the production. You are required to present the relevant Excel report.

(b)Mr Zhang had just formed a new day-shift team to be led by a newly promoted supervisor Mrs Rosalinda. The average age of workers in the team is 30 years old and they have an average of six years sewing experience. What is your estimate of the team's production?

(c)Interpret the coefficient of multiple determination and the adjusted coefficient of multiple determination. Explain which is a better measure in this case. You are required to present the relevant Excel report.

(d) Execute hypothesis tests to advise Mr Zhang which variable(s) is/are significant at the 5% significance level. Write down your steps carefully.

Team Production Experience Age Shift Gender 1 54 4.8 30.5 TEAM: Team 1 to 20 57 4.1 31.3 PRODUCTION: Production volume for each team (units per day) 98 5.0 29.6 EXPERIENCE: Average sewing experience in each team (years) 64 4.7 30.5 O AGE: Average age of workers in each team (years) 104 6.5 26.2 O SHIFT: 1 means day-shift 65 5.4 32.0 0 means night-shift 99 5.6 27.5 GENDER: 1 means team leader is male 58 2.7 30.8 0 means team leader is female 9 85 5.4 29.5 10 59 4.5 31.2 11 63 3.2 30.5 12 67 3.8 33.5 13 97 5.5 30.0 14 94 5.8 30.3 15 78 3.3 31.1 16 56 4.5 29.5 17 66 3.8 30.6 18 55 5.0 30.5 19 92 4.8 27.5 20 52 4.5 30.4