• +44-190-022-0819 +44-190-022-0819
  • +1-248-268-9041 +1-248-268-9041
  • +61288800241 +61288800241

SEARCH SOLUTION

Search your solution from list of 1000+ questions

28-08-2018

Product code: Accounts-AW477

 

Doing regression analysis on Excel is a two-step process. Complete the following:

  1. Install the Analysis Tool-Pak on your PC.
  2. Run the regression analysis.

The Analysis Tool-Pak is an Excel add-in. The Analysis Tool-Pak is part of Excel, but is not installed in the typical initial installation.

 

The directions on this handout are based on Excel 2007. If you have a different version of Excel, the steps below will be the same, but their location on the menu may be somewhat different. Consult the “Help” function for specifics about your version of Excel.

  1. To install the Analysis Tool-Pak on your PC:
    1. Click on the “Office” button (the yellow circle on the upper left corner of the screen), then click the “Excel Options” button at the bottom.
    2. Click “Add-Ins” on the left panel.
    3. Select “Excel Add-Ins” from the dropdown list at the bottom. Then click “Go.”
    4. Select the “Analysis Tool-Pak” check box in the “Add-Ins” dialog box, and then click “OK.”
    5. If an alert appears that asks if you want to install the Add-In, click yes.
  2. Enter your data and run the regression analysis.
  3. Enter the data to be used for your problem. Data must be entered by columns, with the independent variables (x-variables) in adjacent columns.
  4. The dependent variable can be entered in ether the left or right column of your spreadsheet. For purposes of running the example in this handout, enter the data below as shown.

 

 

 

  1. Click on “Data” (top menu bar), then “Data Analysis,” then “Regression,” and then “OK.”
  2. Place the cursor in the “Input Y Range” box.  Highlight the range of cells on the spreadsheet that contain the y-variable. 
  3. Place the cursor in the “Input X Range” box.  Highlight the range of cells on the spreadsheet that contain the x-variables.  (Recall that they should be entered in adjacent rows or columns.)
  4. Click on the “Output Range” button.  Place the cursor in a blank cell on the spreadsheet where no spreadsheet content currently appears (either below or to the right of the cell).  (Cell A10 should work for this example.)  Click on that cell, and the cell address will appear in the box next to Output Range.  This cell represents the upper-left corner of the location where your regression output will appear.
  5. Click “OK” on the regression dialog box.  The regression output will appear.  You may need to widen the column widths on your spreadsheet to get the entire variable label to appear.

 

 

  1. To help you locate important results, the following are highlighted in yellow. (These are discussed in the textbook.) They are not highlighted in the default output of Excel.
    1. Intercept and variable coefficients
    2. Standard error of the intercept and of each coefficient
    3. T-statistic of the intercept and of each coefficient
    4. The probability of obtaining a t-statistic of this value, given that the null hypothesis (the intercept or variable coefficient) is zero. (The null hypothesis holds.)
    5. The 95% confidence interval for the variable coefficient and the intercept.
    6. The adjusted R-square value
    7. The F-statistic and its significance

Complete the following:

  1. 1. Chapter 5, Technical Questions 1 and 5 in the textbook.
  2. Follow these instructions for completing and submitting your assignment:
  3. 1 Place all answers, both numerical and written, in a single excel spreadsheet and use the yellow highlighter on the top menu bar to highlight your final answer.

 

QUES 1.

  1. 1. The following table shows data for a simple production function.
  2. a. From the information in the table, calculate marginal and average products.
  3. b. Graph the three functions (put total product on one graph and marginal and average products on another).
  4. c. For what range of output does this function have diminishing marginal returns?
  5. d. At what output is average product maximized?
  6.  

 

 

QUES 2.

  1. The following table shows data for the simple production function used in Question 1. Capital costs this firm $20 per unit, and labor costs $10 per worker.
  2.  

 

 

  1. a. From the information in the table, calculate total fixed cost (TFC), total variable cost (TVC),total cost (TC), average fixed cost (AFC),average variable cost (AVC), average total cost(ATC), and marginal cost (MC).
  2. b. Graph your results, putting TFC, TVC, and TC on one graph and AFC, AVC, ATC, and MC on another.
  3. c. At what point is average total cost minimized? At what point is average variable cost minimized?
Download Questions

Product code: Accounts-AW477

Related Questions in (Accounting)

13-01-2018

Solution: The Journal of Helene Berr and Rue Ordener, Rue Labat 2 evidences that prove the difficulty and destructiveness that the people had to face in those four years. As mentioned by Berr (2009, p.23), in h ...

18-01-2018

Solution: Employee communication highlights the sharing of ideas and information. In this competitive business world, information exchange is essential among employees to develop team performance effectively. m ...

18-01-2018

Solution: As per Section 1 of the Thirteenth year plan describes about China’s two key objectives that will be accomplished if the National People’s Congress or the standing committee of this party passes t ...

18-01-2018

Solution: (Feldman 2005) reference information extraction to be one of the weightiest pre-processing method that escalates the text mining potential significantly. Pre-processing is an essential part in informa ...

18-01-2018

Solution: The pro forma income statement represents a trending statement that includes the probable net income value for the company considering the current growth and decline rates valid throughout the period ...

18-01-2018

Solution: Mode is defined as the value which occurs more frequently in the data set. The mode for non-business is 82 while for business is only 59. P value can be calculated from z table . As per z table p valu ...

18-01-2018

Solution: ABC assumes that there are different activities involved in different processes that cause costs andthe product, services, and customers are reasons for those activities. The UK customer segment is br ...

19-01-2018

Solution: Residual earnings valuation method is used to calculate the intrinsic value of the stock based on the expected residual income of the company in the coming years. The residual income is discounted bac ...