MAT 135 Project 1 Fall 2018 Please NOTE: (If you cannot open the data files after download, email Prof. Clayton right away. Files are not locked.) Work will be submitted as Email attachments. Best way to NAME your file is in the format "MAT 135-LastName First Name Data1" (or Data2 respectively). Only EXCEL files, pdf files and word files are accepted. Do NOT send zip files and do NOT submit links to cloud files. Do not submit project work in the body of an email. You will need to use Micorsoft EXCEL for this project and is meant to be done with EXCEL 2016. Do NOT work it with the graphing calculator and do NOT work it with any other spreadsheet program. (The only thing to do with the calculator is to take the square root of a number, Do not utilize the calculator for any other portion of this project.) Older versions of EXCEL are acceptable to use for project 1, but for EXCEL 2016 the "NEED TO KNOW" portion below (at the end of this project handout) will match up best Please note that for project 2 you will need EXCEL 2016 and you won't be able to use an Apple computer for Project 2. For this first project, working it on an apple computer should be fine. Our AACC computer labs have the correct (newest) version of Microsoft ExCEL installed and can be utilized for any project if your home computer does not fit the specifications above. . To download "Office 365," which includes EXCEL 2016, go to your AACC email (through MyAACC, NOT through Canvas) and click on the office 365" tab in the black ribbon on the top in your AACC email. This is an active link. By being a Maryland college student, you are entitled to download Microsoft office 365 for free. If you have any questions on how to locate or install it, call the AACC help desk Two EXCEL data sets are provided for this project. Both have to be used. The data sets are posted with this project assignment and are named Data 1, Data 2 The data was collected from male Australian teenagers in 2014 This project asks you to create the following with EXCEL: scatterplots, regression lines, correlation coefficients as well as identify and decide on the use of outliers Make sure your completed graphs do not show large areas of blank space. Make . sure your axes are labeled and that your graph has a descriptive title. . In the data set, each student has an ID. This column is NOT to be used as a variable. eIt is best to give explanations in text boxes within the EXCEL sheet, but an extra word or pdf document will be accepted. Please do not type answer sentences to questions in a single EXCEL cell, only numbers etc NEED to KNOW pointers are provided on page 3 of this handout. Ask Prof. Clayton if you have questions. THE PROJECT 1) For Data 1: Use the two variables to display a) With EXCEL, create a scatterplot of these variables with correctly labeled axes and title. b) With EXCEL, make the regression line appear in the same picture. c) With EXCEL, find and display the equation of the regression line. d) With EXCEL, find and display the squared correlation coefficient. e) With your calculator and the result from (d), calculate the correlation coefficient and report it -page 1 of 3- MAT 135 Project 1 Fall 2018 Please NOTE: (If you cannot open the data files after download, email Prof. Clayton right away. Files are not locked.) Work will be submitted as Email attachments. Best way to NAME your file is in the format "MAT 135-LastName First Name Data1" (or Data2 respectively). Only EXCEL files, pdf files and word files are accepted. Do NOT send zip files and do NOT submit links to cloud files. Do not submit project work in the body of an email. You will need to use Micorsoft EXCEL for this project and is meant to be done with EXCEL 2016. Do NOT work it with the graphing calculator and do NOT work it with any other spreadsheet program. (The only thing to do with the calculator is to take the square root of a number, Do not utilize the calculator for any other portion of this project.) Older versions of EXCEL are acceptable to use for project 1, but for EXCEL 2016 the "NEED TO KNOW" portion below (at the end of this project handout) will match up best Please note that for project 2 you will need EXCEL 2016 and you won't be able to use an Apple computer for Project 2. For this first project, working it on an apple computer should be fine. Our AACC computer labs have the correct (newest) version of Microsoft ExCEL installed and can be utilized for any project if your home computer does not fit the specifications above. . To download "Office 365," which includes EXCEL 2016, go to your AACC email (through MyAACC, NOT through Canvas) and click on the office 365" tab in the black ribbon on the top in your AACC email. This is an active link. By being a Maryland college student, you are entitled to download Microsoft office 365 for free. If you have any questions on how to locate or install it, call the AACC help desk Two EXCEL data sets are provided for this project. Both have to be used. The data sets are posted with this project assignment and are named Data 1, Data 2 The data was collected from male Australian teenagers in 2014 This project asks you to create the following with EXCEL: scatterplots, regression lines, correlation coefficients as well as identify and decide on the use of outliers Make sure your completed graphs do not show large areas of blank space. Make . sure your axes are labeled and that your graph has a descriptive title. . In the data set, each student has an ID. This column is NOT to be used as a variable. eIt is best to give explanations in text boxes within the EXCEL sheet, but an extra word or pdf document will be accepted. Please do not type answer sentences to questions in a single EXCEL cell, only numbers etc NEED to KNOW pointers are provided on page 3 of this handout. Ask Prof. Clayton if you have questions. THE PROJECT 1) For Data 1: Use the two variables to display a) With EXCEL, create a scatterplot of these variables with correctly labeled axes and title. b) With EXCEL, make the regression line appear in the same picture. c) With EXCEL, find and display the equation of the regression line. d) With EXCEL, find and display the squared correlation coefficient. e) With your calculator and the result from (d), calculate the correlation coefficient and report it -page 1 of 3
