Use Excel This is a regression model. Using excel estimate the values of the unknowns ie A,B,C,D.

Database System Concepts
7th Edition
ISBN:9780078022159
Author:Abraham Silberschatz Professor, Henry F. Korth, S. Sudarshan
Publisher:Abraham Silberschatz Professor, Henry F. Korth, S. Sudarshan
Chapter1: Introduction
Section: Chapter Questions
Problem 1PE
icon
Related questions
Question

Answer the given question with a proper explanation and step-by-step solution.

Use Excel

This is a regression model. Using excel estimate the values of the unknowns ie A,B,C,D.

Q.3
Consider the following data where D = 1 means female and 0 means male
Salary Experiei Gender
S
X
D
1330.2499
1385.2678
1565.8174
1458.5257
1353.8157
1408 2934
1431.926
1565.5809
1443.7959
1483.0204
1599.472
1470.5274
1617.9247
1718,7204
1703.3503
1630.7306
1667.9592
1498.6111)
1768-1802
1599.1891
1504,1108
1634.1951
1783.1123
1787.738
1603.2099
1708.2812
1609,9985
1829.917
1657 3461
1616.3588
1796.8719
1628.0731
1670.1083
1765.6029
1818.515
1719.0878
1797.1136
1940.7297
1716.1736
1842 8886
1730.2499
1785.2678
1965.8174
1858.5257
1753.8157
1808.2934
1831.926
1965.5809
1843.7959
1883.0204
1999.472
1870 5274
2017.9247
2118,7204
2103.3503
1
2
3
4
5
6
7
X
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
1
D
1
0
0
0
1
1
0
0
1
1
1
0
6
1
0
1
D
1
1
0
0
0
1
1
0
0
0
1
1
1
0
0
1
1
0
0
0
1
1
0
1
1
1
1
O
0
0
0
0
1
1
0
a. Estimate the model Sa+b*D+c *X and test the hypothesis that b=0.
b. Estmate the model S = a + b*X+c*DX and test the hypothesis that c = 0
c. Estimate the model Sa+b*D+c*X+d*DX and test the hypothesis that b-d=0
Transcribed Image Text:Q.3 Consider the following data where D = 1 means female and 0 means male Salary Experiei Gender S X D 1330.2499 1385.2678 1565.8174 1458.5257 1353.8157 1408 2934 1431.926 1565.5809 1443.7959 1483.0204 1599.472 1470.5274 1617.9247 1718,7204 1703.3503 1630.7306 1667.9592 1498.6111) 1768-1802 1599.1891 1504,1108 1634.1951 1783.1123 1787.738 1603.2099 1708.2812 1609,9985 1829.917 1657 3461 1616.3588 1796.8719 1628.0731 1670.1083 1765.6029 1818.515 1719.0878 1797.1136 1940.7297 1716.1736 1842 8886 1730.2499 1785.2678 1965.8174 1858.5257 1753.8157 1808.2934 1831.926 1965.5809 1843.7959 1883.0204 1999.472 1870 5274 2017.9247 2118,7204 2103.3503 1 2 3 4 5 6 7 X 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51 52 53 54 55 1 D 1 0 0 0 1 1 0 0 1 1 1 0 6 1 0 1 D 1 1 0 0 0 1 1 0 0 0 1 1 1 0 0 1 1 0 0 0 1 1 0 1 1 1 1 O 0 0 0 0 1 1 0 a. Estimate the model Sa+b*D+c *X and test the hypothesis that b=0. b. Estmate the model S = a + b*X+c*DX and test the hypothesis that c = 0 c. Estimate the model Sa+b*D+c*X+d*DX and test the hypothesis that b-d=0
Expert Solution
steps

Step by step

Solved in 3 steps

Blurred answer
Knowledge Booster
System Model Approaches
Learn more about
Need a deep-dive on the concept behind this application? Look no further. Learn more about this topic, computer-science and related others by exploring similar questions and additional content below.
Similar questions
  • SEE MORE QUESTIONS
Recommended textbooks for you
Database System Concepts
Database System Concepts
Computer Science
ISBN:
9780078022159
Author:
Abraham Silberschatz Professor, Henry F. Korth, S. Sudarshan
Publisher:
McGraw-Hill Education
Starting Out with Python (4th Edition)
Starting Out with Python (4th Edition)
Computer Science
ISBN:
9780134444321
Author:
Tony Gaddis
Publisher:
PEARSON
Digital Fundamentals (11th Edition)
Digital Fundamentals (11th Edition)
Computer Science
ISBN:
9780132737968
Author:
Thomas L. Floyd
Publisher:
PEARSON
C How to Program (8th Edition)
C How to Program (8th Edition)
Computer Science
ISBN:
9780133976892
Author:
Paul J. Deitel, Harvey Deitel
Publisher:
PEARSON
Database Systems: Design, Implementation, & Manag…
Database Systems: Design, Implementation, & Manag…
Computer Science
ISBN:
9781337627900
Author:
Carlos Coronel, Steven Morris
Publisher:
Cengage Learning
Programmable Logic Controllers
Programmable Logic Controllers
Computer Science
ISBN:
9780073373843
Author:
Frank D. Petruzella
Publisher:
McGraw-Hill Education