#### Step 1. Place your order

Fill in the order form and provide all details of your assignment.

#### Step 2. Make Payment

Choose the payment system that suits you most.

#### Step 3. Receive your paper

# About the FEVS 2020 Data Set The data set has been truncated from the original

**Place your order now for a similar assignment and have exceptional work written by our team of experts, At affordable rates**

**For This or a Similar Paper Click To Order Now**

About the FEVS 2020 Data Set The data set has been truncated from the original FEVS2020 data set (truncated from N=600,000+ to N=11,709 – once data set is cleaned). This allows the data set to be more manageable in Excel. The data set is clean and already recoded, except for one variable Age40Up. You should recode this variable (use the recode formula instructions below and also available in an inserted comment on the Excel file). Because recoding and cleaning data make up an important step in data analysis, we wanted to provide you with the opportunity to recode at least one variable.

This FEVS data set contains two sheets on the Excel file. The two sheets are 1) the actual data set sheet and 2) the codebook. The codebook explains the variables, which are the survey questions. It explains how each variable is coded.

Recode Instructions:

For the “age40up” variable, students should recode the values, so the age variable becomes a dichotomous/dummy variable with numerical values. Your reference value will be “40 and under”, which should be coded as 0.

Insert a column directly to the right of the column for “age40up”. The column letter is “D” for my data set, but may be a different letter for you. Column D is the original column for the “age40up” variable. So, the new column you insert to the right will become column E. Name this new column/variable “age40up+” (the “+” differentiates it from your original “age40up” variable). In cell E2 of your new “age40up+” variable, enter the following formula:

=IF(D2=”A”,0,

IF(D2=”B”,1,

IF(D2=””,”BLANK”)))

This statement tells Excel that the value of E2 should be:

0 if D2 contains A

1 if D2 contains B

BLANK if D2 is blank

Then copy the content of this cell all the way down to the end of the data (you can double-click the cell’s corners to auto-copy to the end of the data). This allows the functions to reflect in every cell of the column/variable.

After that, copy the entire column and then paste-over as a Values(V) paste (command+V key for MAC). This eliminates the functions in the cells and allows you to delete the original reference column. (NOTE: You must delete the reference column, that is the original column D, since the data in the original column contains letters/text. Excel cannot run the regression if you have non-numeric data).

Be sure to use the column filter feature to eliminate cells with blanks. Once you have eliminated all blanks, the data should be clean and ready for analysis in Excel.

Multiple Regression Steps for Excel

After you have recoded the “age40up” variable, you are ready to run the regression.

Open the Data Analysis window and choose regression.

Click in the Input Y Range to activate.

Select cells B1 through B11710 (this is the “Q12-performview” variable, your dependent variable) (a quick way to highlight all the cells in the column is to first select the first cell (B1). Then “hold down the shift key, CTRL key, and the down key” at the same time. Once you are finished selecting these cells, $B$1:$B$11710 will appear in the Input Y Range box.

Click on Input X Range to activate. (NOTE: Because you are doing multiple regression, all the data for the main independent variable plus control variables need to be selected here– that means all the other data columns). A quick way to do this is: First, select cells C1 through Q1. (Remember, initially, you are highlighting just the first row). Once C1 through Q1 is selected, “hold down the shift key, CTRL key, and the down key” at the same time, to select the rest of the data in all those columns.

Again, after selecting all these data, they should appear in the Input X Range field in the box as in the following: $C$1:$Q$11710

Be sure and click Labels.

Specify where your output table will go under the output options (example: new worksheet, etc.) and click OK.

**Place your order now for a similar assignment and have exceptional work written by our team of experts, At affordable rates**