Description
See attached
Unformatted Attachment Preview
Purchase answer to see full attachment
Explanation & Answer
Please find the answer in docs along with excel file. Thank you.
Answer
Rearranging the data as shown in excel(Sheet Q1_Regression).
The using
Data→Data Analysis-→ Regression
Excel output is shown below
The regression equation can be written as
𝑦 = 196.57 − 43.57𝑥1 − 51𝑥2
‘Interpretation
𝛽0 =. It is the average number of problems per 100 vehicles (PP100) for a Korean automobile
manufacturers. Because it is the intercept when both x1 and x2 is equal to 0.
𝛽1 = It indicates that when keeping all other variables as constant,the average number of
problems per 100 vehicles(PP100) for a European automobile manufacturers reduces by 51
compared to Korean automobile manufacturers.
𝛽2 = It indicates that when keeping all other variables as constant,the average number of
problems per 100 vehicles(PP100) for a domestic automobile manufacturers reduces by 43.57
compared to Korean automobile manufacturers
Answer
The null and alternative hypothesi...