Cellon, a manufacturer of a home insulation, wants to develop guidelines for builders and consumers regarding the effects (1) of the thickness of the insulation in the attic of a home and (2) of the outdoor temperature on natural gas consumption. In the laboratory they varied the insulation thickness and temperature.

Cellon, a manufacturer of a home insulation, wants to develop guidelines for builders and consumers regarding the effects (1) of the thickness of the insulation in the attic of a home and (2) of the outdoor temperature on natural gas consumption. In the laboratory they varied the insulation thickness and temperature. Please provide formulae and work in excel format. File is attached.

The following sample observations were randomly selected.

The following sample observations were randomly selected. Determine the coefficient of correlations and the coefficient of determination. Interpret the association between X and Y. Please show all work in excel format

Neilsen Media Research wants to pretest a questionnaire to be mailed to several thousand viewers. One question involves the ranking of male and female college students with respect to the popularity of programs. The composite rankings of a small group of college students are:

Neilsen Media Research wants to pretest a questionnaire to be mailed to several thousand viewers. One question involves the ranking of male and female college students with respect to the popularity of programs. The composite rankings of a small group of college students are: (See attached file for full problem description)

The manager of a computer software company wishes to study the number of hours senior executives spend at their desktop computers by type of industry. The manager selected a sample of five executives from each of three industries.

The manager of a computer software company wishes to study the number of hours senior executives spend at their desktop computers by type of industry. The manager selected a sample of five executives from each of three industries. At the .05 significance level, can she conclude there is a difference in the mean number of hours spent per week by industry?

The Tampa bay (Florida) Area Chamber of Commerce wanted to know whether the mean weekly salary of nurses was larger than that of school teachers. To investigate, they collected the following information on the amounts earned last week by a sample of school teachers and nurses.

The Tampa bay (Florida) Area Chamber of Commerce wanted to know whether the mean weekly salary of nurses was larger than that of school teachers. To investigate, they collected the following information on the amounts earned last week by a sample of school teachers and nurses. Questions: Is it reasonable to conclude that the mean weekly salary of nurses is higher? What is the p value? Please show all work and answers in excel format.