ADMS 3330 Study Guide - Final Guide: Coefficient Of Determination, Analysis Of Variance
Get access
Related Documents
Related Questions
On an excel sheet answer the following questions:
Q=Quantity (in 100s) of aspirin purchased in a year
P= Average price of aspirin in that year
Y=Annual income
A=Age of buyer
Q1. If we divide the population into two groups, up to age 35 and over age 35, which group purchases more aspirin?
Q2. Divide the population into three groups- up to age 30, over 30 and up to 45, and over 45. Do the purchases vary by age?
Q3. What is the relationship in a regression analysis between Q and P? Between Q and Y? Between Q and A?
Observation | Q | P | Y | A |
1 | 1 | 1.5 | 20 | 25 |
2 | 2 | 1.5 | 40 | 20 |
3 | 4 | 1 | 12 | 25 |
4 | 2 | 1 | 10 | 30 |
5 | 2 | 1 | 8 | 30 |
6 | 3 | 2 | 30 | 35 |
7 | 3.5 | 1.5 | 30 | 40 |
8 | 4 | 2 | 20 | 40 |
9 | 7 | 1 | 20 | 45 |
10 | 1 | 3 | 15 | 40 |
11 | 2 | 2 | 18 | 30 |
12 | 3 | 2 | 20 | 32 |
13 | 3.5 | 2 | 15 | 36 |
14 | 4 | 2 | 10 | 30 |
15 | 2 | 3 | 25 | 20 |
The following data are for 30 observations involving twocategorical variables, x and y. The categories for x are A, B, andC; the categories for y are 1 and 2.
Observation | x | y | Observation | x | y | |
1 | A | 2 | 16 | B | 1 | |
2 | B | 2 | 17 | C | 2 | |
3 | B | 2 | 18 | B | 2 | |
4 | C | 1 | 19 | C | 2 | |
5 | B | 2 | 20 | B | 2 | |
6 | C | 1 | 21 | C | 1 | |
7 | B | 2 | 22 | B | 2 | |
8 | C | 1 | 23 | C | 1 | |
9 | A | 1 | 24 | A | 1 | |
10 | B | 2 | 25 | B | 2 | |
11 | A | 1 | 26 | C | 1 | |
12 | B | 2 | 27 | C | 1 | |
13 | C | 1 | 28 | A | 1 | |
14 | C | 1 | 29 | B | 2 | |
15 | C | 1 | 30 | B | 1 |
Develop a crosstabulation for the data, with x as the rowvariable and y as the column variable.
y | ||||
1 | 2 | Total | ||
A | ||||
x | B | |||
C | ||||
Total |
Compute the row percentages (to 1 decimal).
y | ||||
1 | 2 | Total | ||
A | % | % | % | |
x | B | % | % | % |
C | % | % | % | |
Compute the column percentages (to 1 decimal).
y | ||||
1 | 2 | |||
A | % | % | ||
x | B | % | % | |
C | % | % | ||
Total | % | % |