regression & answer the quastions in attached

User Generated

eno3nu

Economics

eco511

ubt

Description

This an assignment You have to enter the production data in Excel, transform the data to log linear as shown also in the table. Conduct the regression analysis on the log linear data. Verify that your results are matching the results I already provided. Prepare a report of 2-3 pages based on the results, through answering the questions shown on the first page.
with Excel worksheets attached and report

Unformatted Attachment Preview

Production Estimates A new Saudi producing breads and pastries using modern techniques is interested in developing a production function for its products. The data from 15 outlets were collected and presented in the next table. 1) 2) 3) Questions: Write the function in log linear form? Test weather the coefficients of labour and capital are statistically significant? Test weather the independent variables in the regression equation are significant in explaining sales of this company What is the explanatory power of the model? What type of return to scale in this production function, explain? Explain what the coefficents mean? 4) 5) Production Data Outlet Sale(SR000) Labor(SR000)Capital(SR000) 1 657.3 162.3 280 2 935.9 214.4 542.5 3 1110.7 186.4 721.5 4 1200.9 245.8 1167.7 5 1052.7 211.4 811.8 6 3406 690.6 4558 7 2427.9 452.8 3069.9 8 4257.5 714.2 5585 9 1625.2 320.5 1618.8 10 1272.1 253.2 1562.1 11 1004.5 236.4 662 12 598.9 140.7 875.4 13 853.1 145 1697 14 1165.6 240.3 1078.8 15 1917.6 536.7 2109.3 1565.7 316.7 1756 Log Sale Log Labor log Capital 2.817764 2.210319 2.447158 2.971229 2.331225 2.7344 3.045597 2.270446 2.858236 3.079507 2.390582 3.067331 3.022305 2.325105 2.909449 3.532245 2.839227 3.658774 3.385231 2.655906 3.487124 3.629155 2.85382 3.747023 3.210907 2.505828 3.209193 3.104521 2.403464 3.193709 3.00195 2.373647 2.820858 2.777354 2.148294 2.942207 2.931 2.161368 3.229682 3.06655 2.380754 3.032941 3.282758 2.729732 3.324138 Average Production Function Estimation SUMMARY OUTPUT Regression Statistics Multiple R 0.978763 R Square 0.957977 Adjusted R Square 0.950973 Standard Error 0.054056 Observations 15 ANOVA df SS MS F Significance F 136.7784 5.51E-09 Regression Residual Total 2 12 14 0.799355 0.035065 0.83442 0.399677 0.002922 t Stat P-value Coefficients Standard Error 0.621929 0.153304 Lower 95% 0.287907 Upper 95% 0.955951 Lower 95.0% Upper 95.0% 0.287907 0.955951 4.056823 Intercept Log Labor log Capital 0.771431 0.199528 0.534206 0.108878 0.071523 0.001591 1.27E-05 0.016354 7.08529 2.789689 1.008655 0.355364 0.534206 0.043692 1.008655 0.355364 0.043692
Purchase answer to see full attachment
User generated content is uploaded by users for the purposes of learning and should be used following Studypool's honor code & terms of service.

Explanation & Answer

Thank you so much

Outlet
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
Average

Sales(SR000) Labor(SR000)Capital (SR000) Log sale log labor
657.3
162.3
280 2.81776 2.21032
935.9
214.4
542.5 2.97123 2.33122
1110.7
186.4
721.5
3.0456 2.27045
1200.9
245.8
1167.7 3.07951 2.39058
1052.7
211.4
811.8
3.0223
2.3251
3...


Anonymous
Just the thing I needed, saved me a lot of time.

Studypool
4.7
Trustpilot
4.5
Sitejabber
4.4

Related Tags