ECON 1011 Lecture Notes - Monda
10 views14 pages
Get access
Grade+20% off
$8 USD/m$10 USD/m
Billed $96 USD annually
Homework Help
Study Guides
Textbook Solutions
Class Notes
Textbook Notes
Booster Class
40 Verified Answers
Class+
$8 USD/m
Billed $96 USD annually
Homework Help
Study Guides
Textbook Solutions
Class Notes
Textbook Notes
Booster Class
30 Verified Answers
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 |