Please show steps for google sheets. Questions/Tasks 1. What is the explanatory variable in this study? What is the resp

[answerhappygod]

Please show steps for google sheets.
Questions/Tasks
1. What is the explanatory variable in this study? What is theresponse variable?
2. Use the analysis tool pack to conduct the appropriatet-test.
Researchers wanted to determine if carpeted rooms contained morebacteria than uncarpeted rooms. To determine the amount of bacteriain a room, researchers pumped the air from the room over a Petridish at the rate of 1 cubic foot per minute for eight carpetedrooms and eight uncarpeted rooms. Colonies of bacteria were allowedto form in the 16 Petri dishes. The results are in table belowResearchers wanted to determine if carpeted rooms contained morebacteria than uncarpeted rooms. To determine the amount of bacteriain a room, researchers pumped the air from the room over a Petridish at the rate of 1 cubic foot per minute for eight carpetedrooms and eight uncarpeted rooms. Colonies of bacteria were allowedto form in the 16 Petri dishes.
The results are in the table below Carpeted rooms Uncarpetedrooms
Bacteria/cubic foot Bacteria/cubic foot