| CSC1009 Quiz 4 | Contact Info |

   
Herbert J. Bernstein Professor of Computer Science
Dept. of Mathematics and Computer Science, 1300 William Floyd Parkway, B205, Shirley, NY 11967

90466 CSC 1009N -- Introduction to Spreadsheets and Data Analysis -- Fall 2012
Online Course

Quiz 4

 

This web page is http://www.bernstein-plus-sons.com/.dowling/CSC1009F12/CSC1009_Quiz_4.html
Copyright © 2009, 2012 Herbert J. Bernstein and other parties. All rights reserved.


This is the weekly quiz for 9 October 2012 for the CSC 1009 course. Please do this quiz after you have completed the rest of assignment 4. It should take between one half hour and 2 1/2 hours to complete if you are well prepared, longer if not. Please recall that your were supposed to have the Gips textbook and to have read through page 380 (through Chapter 19).

  <==== Do this AFTER you've answered all the questions

You probably DON'T want to do this ===>  

Please fill in the following information:

Name:


Email:


Skype ID:

  1. Carefully explain what a table or list is. Be sure to explain the terms record, field and header.

  2. Explain how to sort a table in Excel.

  3. Explain how to find records with filters.

  4. Explain what a total row of a table it and how to create it.

  5. Explain what a pivot table is, how to create it and how to use it.

  6. According to Gips, explain what the Analysis Toolpak is, how to get it and how to install it.

  7. Explain what the histogram tool does.

  8. Explain what the correlation tool does.

  9. Explain what the t-test tool does.

  10. Explain what the regression tool does.

  11. According to GIPS, explain what the solver tool does, and give a detailed example of its use.

  <==== Do this AFTER you've answered all the questions

You probably DON'T want to do this ===>  

Revised 5 October 2012