Basic Excel Help:If you haven’t worked with excel for a long time and don’t remember how to create and copy formulas, or other basic operations then the next few pages of this booklet may be of help (Note: it is not specifically designed for this assignment so you’ll have to follow the procedure with different variables, etc). The tutorial shows step by step how to do these basic operations in the older version of excel—but the methodology is the same for the newest excel version. Otherwise, the only excel components that some of you may need assistance with are as follows:

Graphing in Excel

Once your data is prepared click on the Insert Tab.

Then click on “Line” and select one of the templates from the drop down list.

Within the chart area, right click to “select data” or click on the “select data” button in the header

In upper box (chart data range) select your entire spreadsheet of data (but not the column headings)

A dialog box asks you to ADD in the data for the Y axis (on lefthand side) and X axis (right hand side)

When you ADD in a column of data it will ask you to give it a “name” and then to select its values. Click on the icon of a spreadsheet for selecting values and then highlight the column of data you want it to read in. Once done, click the spreadsheet icon again and it takes you back to the former screen. ADD in all relevant Y columns. Then ADD or EDIT the x information to make sure it’s selecting the right data.

Regression in Excel

Click on the Data Tab and look for “Data Analysis”.

  • If your computer hasn’t loaded the Analysis Toolpak it may be missing. In this case hit the upper lefthand icon (that brings up options like save, print, etc) and select Excel Options. Then Select “Add Ins” and then Analysis Toolpak. This will add Data Analysis into your Data Tab.

Select Regression from the drop down list.

Input the Y values (the dependent variable) just as you did in the graphing exercise

Input the X values (the independent variables)..here, you can select all of the relevant data at once.

Click OK.

Step 1: Create the column headings for the variables needed.

Step 2: Begin filling in each column using the appropriate formulas discussed in class. To enter a formula into a cell first type “+” or “=” to signal the computer you are going to write a formula. To make cell references, you can either type the cell name (column row) or click on it.

Step 3: Filling in columns (dragging down your formulas to fill in at every quantity).

SHORTCUT: HIGHLIGHTING AND FILLING IN COLUMNS.

Example: Start with Price. Highlight the cell that has the formula in it you want to use to fill in the rest of the column (this should be the first entry in your price column); a highlighted cell is created by clicking on it. Notice in the bottom right corner there is a tiny square. Click on that square and drag the outline down so it fills up the entire column of your table. If you are doing it right there will be a gray box that follows your motions. When you release the button on the mouse, the formula will have copied and pasted in all the rows.

Repeat this operation for all empty columns (i.e, MC, AFC, AVC, etc.)

Your screen will look similar to the ones given below.

Step 4: Print your formulas. Hold down the CTRL button and hit ` (upper left corner of most keyboards) to reveal all of your formulas instead all the numbers you’ve generated. It will look something like the one given here below (ignore my problem with MC…I didn’t see it was blank before I copied it here!)