A researcher in the insurance industry is interested in the time (in months) it takes an insurance firm to adopt an innovation in the way in which business is conducted in the industry. He believes the elapsed time involved can be explained by the size of the firm (total assets in millions of dollars) and the financial organization of the firm (either as a mutual fund or a stock issuing company). The latter variable is a qualitative variable and is entered into the regression model by employing a binary variable (arbitrarily coded 0 = mutual fund and 1 = stock company). He takes a random sample of 20 insurance companies (out of the thousands of insurance companies constituting the population) and generates the following multiple regression solution in Excel.

Additional Requirement

These questions based on the Statistics and it is about a study on the insurance industry where the time it takes for an insurance company to adopt an innovation for its business is studied. The calculations have been performed in Microsoft Excel.

Word limt 1650