-
+1 - 312-224-1615
Get in touch with us
-
support@helpwithassignment.com
Send us an e-mail
Solution Library
Calculate Demand Using Data Of Consumption
Question
Consider the following data for a cross section of individuals in the population, in which:
Q = Quantity (in 100s) purchased in a year
P = Average price of aspirin in that year
M = Annual income (in $1000s)
A = Age of buyer
Calculate Regression using Regression Analysis Program in Excel
|
obs |
Q |
P |
M |
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 |
|
16 |
1 |
4 |
15 |
25 |
|
17 |
8 |
2 |
15 |
55 |
|
18 |
9 |
1 |
40 |
50 |
|
19 |
1 |
4 |
10 |
45 |
|
20 |
10 |
1.5 |
30 |
55 |
|
21 |
6 |
1.5 |
35 |
60 |
|
22 |
2 |
1 |
30 |
40 |
|
23 |
3 |
1 |
25 |
40 |
|
24 |
3 |
2 |
20 |
35 |
|
25 |
3 |
2 |
15 |
35 |
|
26 |
4 |
3 |
20 |
35 |
|
27 |
1 |
4 |
20 |
25 |
|
28 |
1 |
4 |
25 |
30 |
|
29 |
2 |
5 |
28 |
30 |
|
30 |
3 |
1 |
30 |
32 |
Suppose income (M) is $20, the price of aspirin (P) is $2, and the average age of the population (A) is 35. What is the estimated demand for aspirin?
Summary
The question belongs to Statistics and it is about calculating the demand for aspirin using the above table.
Total Word Count 35
Download Full Solution
WHAT OUR STUDENTS SAY
Was partying late night and forgot about my biotechnology assignment which was about to submit in 5 hours. Then approached several service providers but they refused to take up the assignment. Finally TheReliableTutor.com saved me. Submitted the assignment on time..!!!
Jordan Student
I always loved Chemistry but Chemical Engineering was something completely different. I took help from TheReliableTutor.com on several occasions and so far they have delivered the reports on time.
Pallavi Patel Student
The process capability assignment expert at HwA has helped me not only to write my assignment but also to better understand the theorem and ideas. This has helped me to solve the process capability analysis questions in exams and term papers accurately and get top grades.
Shane Filan Student
There are things I failed to get a grasp on in my classes and for that reasons assignments often looked much more challenging for me. However, luckily I came across HwA and from my BSc N course till the final year of my MSc N course I always take their help and get good results.
Jacob Tremblay Student
The accounting tutors here can surely make the numbers talk. In my freshmen year, I was unable to understand what to put under assets and what under liabilities. It was back then I took their help and also helped me understand why “capital investment†is a liability to the business. I am doing my Masters now and still take their help.
Michael Watson Student
Comments
this is a very good website
I have 50 questions for the same test your page is showing only 28
hi can you please help or guide me to answer my assignments. thanks
hi can anyone help or guide me to my assignments. thanks
This solution is perfect ...thanks
Hello Allison,I love the 2nd image that you did! I also, had never heard of SumoPaint, is something that I will have to exolpre a bit! I understand completely the 52 (or so) youtube videos that you probably watched. Sometimes they have what you want, sometimes they don't! However, it is always satisfying when you are able to produce something that you have taught yourself. Great job!Debra 0 likes
Perfect bank of solution.
great !
thanks for the quick response. the solution looks good. :)
thnx for the answer. it was perfect. just the way i wanted it.
works fine.