Purchase Solution

Correlation analysis in Megastat

Not what you're looking for?

Ask Custom Question

Using the Water use data set analyze the data using Excel, MegaStat or whatever statistical software you prefer and report in proper statistical form/jargon about the dataset.

1 58.80 7,107 21 129 52 3,067
2 65.20 6,373 22 141 68 2,828
3 70.90 6,796 22 153 29 2,891
4 77.40 9,208 20 166 23 2,994
5 79.30 14,792 25 193 40 3,084
6 81.00 14,564 23 189 14 3,898
7 71.90 11,964 20 175 96 3,502
8 63.90 13,526 23 186 94 3,060
9 54.50 12,656 20 190 54 3,211
10 39.50 14,119 20 187 37 3,286
11 44.50 16,691 22 195 42 3,542
12 43.60 14,571 19 206 22 3,125
13 56.00 13,619 22 198 28 3,022
14 64.70 14,575 22 192 7 2,922
15 73.00 14,556 21 191 42 3,950
16 78.90 18,573 21 200 33 4,488
17 79.40 15,618 22 200 92 3,295

TEMP = Average monthly temperature (degree Fahrenheit)
PROD = amount of production (thousands of pounds)
DAYS = number of plant operating days in the month
EMPL = number of employees on the monthly plant payroll
LOTTO = the first two digits of that month's LOTTO winner
WATER = the monthly water usage (gallons)

Purchase this Solution

Solution Summary

The solution provides step by step method for the calculation of correlation coefficient . Formula for the calculation and Interpretations of the results are also included.

Purchase this Solution


Free BrainMass Quizzes
Terms and Definitions for Statistics

This quiz covers basic terms and definitions of statistics.

Measures of Central Tendency

Tests knowledge of the three main measures of central tendency, including some simple calculation questions.

Know Your Statistical Concepts

Each question is a choice-summary multiple choice question that presents you with a statistical concept and then 4 numbered statements. You must decide which (if any) of the numbered statements is/are true as they relate to the statistical concept.

Measures of Central Tendency

This quiz evaluates the students understanding of the measures of central tendency seen in statistics. This quiz is specifically designed to incorporate the measures of central tendency as they relate to psychological research.