Mary Lou Jacobs Has Requested That Additional Information Be Included

question 42

Essay

Mary Lou Jacobs has requested that additional information be included in the report shown in the figure below. She has added the text Only of our guests rated the QST tour experience as either Fair or Poor to the bottom of the Word document. You need to fill the space after Only with the percentage of Fair or Poor responses from the source Excel spreadsheet. To carry out the tasks, you will need to apply your knowledge of OLE technology. Describe how to populate cell F20 with the description Fair/Poor and cell G20 with the sum of the data in cells G16 and G17.

---

Definitions:

One-Way ANOVA

A statistical test that compares the means of three or more independent groups to determine if there is a significant difference between them.

Null Hypothesis

The default hypothesis that there is no significant difference or relationship between specified populations, any observed effect is due to sampling or experimental error.

Interaction

In the context of statistics and experimental design, interaction refers to a situation where the effect of one independent variable on the dependent variable varies according to the level of another independent variable.

Factorial ANOVA

A statistical test used to examine the effects of two or more independent variables on a dependent variable simultaneously.