Solve the problem without using EXCEL WORSHEET. The detailed calculation must appear in your ANSWER SHEETS....
Fantastic news! We've Found the answer you've been seeking!
Question:
Transcribed Image Text:
Solve the problem without using EXCEL WORSHEET. The detailed calculation must appear in your ANSWER SHEETS. You can use the calculator. Limit your calculation within 3 dismal points Take the printout of your assignment and attach it while submitting. The table given below shows the performance of students (scores) in econometrics and absenteeism (number of classes they were ahsent). Absenteeism Score in ECON 441 2 76 10 15 60 90 55 84 85 (1) Write down the econometric model. (2) Estimate the lincar regression model and interpret the coefficients (3) Calculate R-Square and interpret its value (4) Examine the relationship between absentecism and score in cconometrics based on correlation coefficient. (5) Ifa student has missed total 12 classes, what is the expected marks of the student in econometries? (6) Test if the slope coefficient is significant. The data was further collected on score of the above 6 students on prerequisite course- Business Statistics (BS) to show how performance in econometrics is affected by both - Absenteeism and Score in Prerequisite course. The multiple linear regression model was run using EXCEL Analysis Tool pack. The partial results are reported in Table below. SUMMARY OUTPUT Regression Statistics Multiple R R Square Adjusted R Square ?? ?? ?? Standard Error 5.734 Observations ?? ANOVA df MS Regression ?? 466.680 Residual ?? ?? Total ?? Coefficients Standard Error 67.634 I Stot 0.657 Intercept 44.463 X Variable 1 X Variable 2 -1892 1.092 -1.732 0.584 0.809 0.722 (a) Do necessary calculations to fill the missing numbers (??) Show all your calculations. Solve the problem without using EXCEL WORSHEET. The detailed calculation must appear in your ANSWER SHEETS. You can use the calculator. Limit your calculation within 3 dismal points Take the printout of your assignment and attach it while submitting. The table given below shows the performance of students (scores) in econometrics and absenteeism (number of classes they were ahsent). Absenteeism Score in ECON 441 2 76 10 15 60 90 55 84 85 (1) Write down the econometric model. (2) Estimate the lincar regression model and interpret the coefficients (3) Calculate R-Square and interpret its value (4) Examine the relationship between absentecism and score in cconometrics based on correlation coefficient. (5) Ifa student has missed total 12 classes, what is the expected marks of the student in econometries? (6) Test if the slope coefficient is significant. The data was further collected on score of the above 6 students on prerequisite course- Business Statistics (BS) to show how performance in econometrics is affected by both - Absenteeism and Score in Prerequisite course. The multiple linear regression model was run using EXCEL Analysis Tool pack. The partial results are reported in Table below. SUMMARY OUTPUT Regression Statistics Multiple R R Square Adjusted R Square ?? ?? ?? Standard Error 5.734 Observations ?? ANOVA df MS Regression ?? 466.680 Residual ?? ?? Total ?? Coefficients Standard Error 67.634 I Stot 0.657 Intercept 44.463 X Variable 1 X Variable 2 -1892 1.092 -1.732 0.584 0.809 0.722 (a) Do necessary calculations to fill the missing numbers (??) Show all your calculations.
Expert Answer:
Answer rating: 100% (QA)
Let x Absenteeism nd y Score in ECON 441 All Calculations are shown below x y x2 y2 xy 10 60 100 3600 600 1 90 1 8100 90 15 55 225 3025 825 6 84 36 70... View the full answer
Related Book For
College Mathematics for Business Economics Life Sciences and Social Sciences
ISBN: 978-0321614001
12th edition
Authors: Raymond A. Barnett, Michael R. Ziegler, Karl E. Byleen
Posted Date:
Students also viewed these accounting questions
-
Accounting measures of performance The table given below shows how, on average, the market value of a Boeing 737 has varied with its age and the cash flow needed in each year to provide a 11% return....
-
Table given below shows initial lengths, changes in temperatures and changes in the length of 3 rods. Find whether these rods are made of same material or not. Change Change TER Lo in T in L A 2L AL...
-
Correlation coefficient and Excel graphing. Synthetic data are given below for a calibration curve in which random Gaussian noise with a magnitude of 80 was superimposed on y values that follow the...
-
Below are three independent and unrelated errors. a. On December 31, 2020, Wolfe-Bache Corporation failed to accrue salaries expense of $1,800. In January 2021, when it paid employees for the...
-
Labor and Material Variances Standard direct-labor rate . $ 15.00 Actual direct-labor rate . $ 11.50 Standard direct-labor hours 10,000 Direct-labor quantity varianceunfavorable $ 9,000 Standard...
-
Gold Star Rice, Limited, of Thailand exports Thai rice throughout Asia. The company grows three varieties of rice-White, Fragrant, and Loonzain. Budgeted sales by product and in total for the coming...
-
Explain what is meant by dynamic world planning.What is meant by probabilistic planning? What is the difference between probabilistic planning and nondeterministic planning?
-
The Polishing Department of Estaban Manufacturing Company has the following production and manufacturing cost data for September. Materials are entered at the beginning of the process. Production:...
-
c. Consider Q=B C, Q2=B C, q = C C, and x=5.0 cm in the figure of right triangle: I. Draw the Free body diagram of electric forces at point of interest (q location) on your working paper by using F...
-
STYLIZE GUI USING CSS AND PRESENT APPLICATION TO STAKEHOLDERS Overview The visual appearance (look and feel) of an application greatly affects its acceptance and usefulness. You need to ensure that...
-
The new technology will cost $21.41 in millions. The cost of capital is 6.8%. The next four years has the following cash flows (in millions) from implementing the new technology. Year 1 2 3 4 3.74...
-
What differences, if any, are there when selecting a bond to construct a community recreation facility versus a high school athletics facility?
-
How do budgeting and forecasting differ?
-
What factors will affect the type of bond that a city will choose to issue for construction of a new recreation facility?
-
How does state tax law affect the financing of parks and recreation facilities and programs?
-
In team sport (professional or college), which form of budgeting should be used?
-
A spherical shell contains three charged objects. The first and second objects have a charge of -15.0 nC and 38.0 nC, respectively. The total electric flux through the shell is -323 N.m/C. What is...
-
Which of the followingcarbocations is the least stable? CH3CH2 . CH3CHCH3 CH3 I . CH3C0 T CH3 IV. V. CH3 CH3CCH2 CH3
-
Write Each system in Problem as a matrix equation of the form AX = B. 3x1 + 2x3 = 9 -x1 + 4x2 + x3 = -7 -2x1 + 3x2 = 6
-
Solve Problem using augmented matrix methods. x1 + 3x2 = 1 3x1 - 2x2 = 14
-
A chain of car muffler and brake repair shops maintains a training program for its mechanics. All new mechanics begin training in muffler repairs. Every 3 months, the performance of each mechanic is...
-
During Chinas Cultural Revolution in the late 1960s and early 1970s, highly educated people were forced to move to farms and work in the fields. Some were common laborers for eight or more years....
-
In elementary school and through middle school, most students have the same teacher throughout the day and for the entire school year. Then, beginning in high school, different subjects are taught by...
-
In Botswana, Zimbabwe, and South Africa, individuals can own and farm elephants. In other African countries, the elephants are put on large reserves. Explain why the elephant population in Botswana,...
Study smarter with the SolutionInn App