Assignment #2 using Excel:
 
Use the data file that you created in assignment #1. The data set should have the original variables with the names IV1, IV2 and DV, as well as the new variables that you created in assignment #1 (i.e. ID, R_IV1, R_IV2, TwoIVs and R_DV). If you made mistakes in assignment 1, you need to correct those mistakes before you work on assignment 2. If you do not correct the mistakes, you will not get the correct answers in assignment 2. ​

Assignment #2 tasks. 

a) Create a box plot for the variable R_IV1. Give the box plot a main title that follows the naming convention, Last name's box plot. For example, my title would be Corwyn's box plot.  Label the x axis, "x axis" and name the y axis, "y axis".
​
b) Create a stem-and-leaf plot for Two_IVs. You must complete all the set up for the stem and leaf shown in the video, including constructing the table for the stem and leaf. You must have at least 4 or more leaves in your plot. You must create all the stems and leaves for full credit, but you can earn half credit if you complete one set of leaves that represents values that appear in the data.
​
c) Create a frequency table for the variable R_IV2.  The frequency table should include the number of occurrences of every value in R_IV2 as well as the cumulative percent of every value, in ascending order.
​​
d) Calculate the sum of all (X-Xbar)^2 values for R_IV1, where X = the R_IV1 values and Xbar is the mean of R_IV1. Remember that ^2 is a symbol for squared. So you will create a variable that has the values of X-Xbar and then you will create a variable that squares the X-Xbar values. Then you will sum all of the values in the last step (see videos).
​
Upload your completed assignment to the submit assignment 2 page.

If you are using Excel, upload your Excel file that you used to complete this assignment. Always turn in only one Excel file in this class. When assignments have multiple questions, you can answer each question in a different sheet in Excel and label the sheets accordingly (e.g. Answer to b, answer to c, etc.). When I look at your Excel file, I should be able to see the tables and plots, as well as the sum of all R_IV1 values. Make sure that you put labels in your Excel file so that it is clear where answers to a, b, c, and d are in the Excel file. For example type "answer to a" in a cell close to the box plot that you produced.
 
Name your file as follows. Last name, First and middle initial (in caps), underscore and assignment2. For example, my name is Robert Flynn Corwyn so my file would be CorwynRF_assignment2.xlsx. Notice that Excel files have the .xlsx extension.
For example, my file would be called CorwynRF_assignment2.xlsx.  Note that you do not have to type ".xlsx" because Excel automatically adds the extension to the name of your file.

Read the instructions carefully. Failing to follow instructions will cost you points. One point will be counted off for failing to follow directions, even if your assignment is otherwise flawless. If you fail to follow more than one instruction, you can be counted off 1 point for each violation. One point will be counted off for failing to tell us where you are answering questions a, b, c, d, etc., and failing to name your file correctly.
.
If you use R, one point will be counted off for failing to read data files from the statlab folder in the C drive and failing to send your .R script file to all instructors and tutors (see instructions for a list of individuals to send your R script file to).  If you use R on a Mac, please enter the code that is needed to read your file on a PC and place # in front of that line (e.g. this is an example of the code we ask Mac uses to include ... #classdataS20<-read_excel("C://statlab/classdataS20.xlsx". If we cannot read your data on a PC, by deleting the # sign and running the line, one point will be taken off.
.
If you use R, please place a # sign in front of any line that installs a library (e.g. #install.packages("readxl")), views data (e.g. #view(classdata)), or updates packages (e.g. #update.packages( ). One point will be taken off for not doing this.If you use Excel, you will miss a question entirely if you do not use formulas in cells where calculations of any kind are made. Do not manually enter data in any cell that the video tells you to use a formula.

This assignment is worth 10 points.