Mary Lou Jacobs, the General Manager of QST Vancouver, Has

question 6

Essay

Mary Lou Jacobs, the general manager of QST Vancouver, has recently attempted to update pasted items in the figure below from the source Excel file. The edits made in Excel were not reflected in the Word document. Ms. Jacobs has several questions for you regarding this problem. If there is no data connection between the table in Word containing Total Tours 250, and the source cells in Excel, why do the table and source cells have an identical appearance?

---

Definitions:

Wilcoxon Signed Rank Test

A statistical analysis method void of parametric requirements, designed to assess whether two associated samples, matched pairs, or recurrent measurements on an individual sample exhibit differences in their mean rank in the population.

Rank Sums

A non-parametric statistical measure used to compare the distributions of two independent samples by ranking all observations together and then summing ranks for observations belonging to each sample.

Standardized Test Statistic

A calculated value used to determine the relative distance of a data point or sample from the mean of a population, expressed in terms of the standard deviation of the population.

Positive Differences

The result obtained when subtracting a smaller number from a larger number in each pair of a data set.