Research methods, computer science homework help
Application Assignment 5 (Microsoft Excel)Practicing with ExcelRead Appendix A on pages 354-360Use the data in figure A.2 and enter them in excel and create anexact table with the column titles. Call table A.2. Save your work forfinal submission.Follow the directions to get from Figure A.2 to Figure A.3 . Usethese steps to create table A.3 similar to figure A.3. Save your workfor final submission.Follow the directions to get from Figure A.3 to Figure A.4 . Usethese steps to create table A.4 similar to Figure A.4. Save your workfor final submission.Follow the directions to get from Figure A.4 to Figure A.5. Usethese steps to create table A.5 similar to figure A.5. Sort your data inTable A.5 by the Person Number in ascending order. Make sure yourhighlight all the table area when you do the soting. Save your work forfinal submission.Use columns M and N (RtScore and PerfScore) and create a scatterchart of the PerfScore vs RtScore (i.e. a on the x axis the RtScore andon the Y axis the PerfScore. Save the graph In the file and make surethe graph is shown. All tables and the graph should be all in one spreadsheet.in one file. Write your class #, your lastand first name at the beginning of the file. Save your excel file as class# Last name, first – application Assignment 5 and submit onMoodle.by the due date and time.Refer textbook here https://bookshelf.vitalsource.com/#/
THIS QUESTION IS UNSOLVED!
Request a custom answer for this question