CS234

Lab Assignment 5

Due

Monday at the start of class.

Purpose

The purpose of this assignment is to have you become familiar with using programs downloaded from the Internet and using them in conjunction with programs such as Excel. In this exercise you will use a digitizing program to gather some data from a plot and do some data analysis on it.

Scenario

A friend of yours who is a biology student needs your help in completing an assignment. Their instructor has given them a data plot (available here). They have been asked to do some statistical analysis and curve fitting. You have consented to help them since you've become a computer wizard by taking CS234.

Your friend does not have the data that was used to form the plot do you will have to use a digitizer program (available here) to gather up the data and perform an analysis using Excel. You friend needs the following statistics/information calculated:

A summary of the data values used in the analysis.
A correlation coefficient for number of plants versus number of reported outbreaks.
A regression equation for number of plants versus year and reported outbreaks versus year. You will need to use multiple or non-straight line regression in one or both cases.
Plots of the data and the regression equations fit to the data.
Any other statistics that might be helpful in describing the data.

The Steps

1
Create a directory called mypage in the temp directory on the computer. Put all your work here.

2
Gather up the image. It is already in .jpg format which is compatable with the digitizer.

3
Download the digitizer and install it. It is available here or locally here.

4
Read the documentation for the digitizer. Use the digitizer to obtain the data points and save them in your temporary directory.

5
Import the data points into Microsoft Excel. Hint: When doing the multiple regression analysis you will need to create an array in which to display the results. To do this highlight a sufficient number of cells to display the results from linest. Enter the parameters for the linest function and then hit <ctrl><shift><enter> simulatanously to fill the array with the results.

6
Using the Visual Page editor create a web page that summarizes all the analysis. Call this page lab05.html. Be sure to included a statistical summary, plots and a narrative that describes the analysis performed.

7
Using a telnet client, log onto mathcssun.

8

In your public_html directory create a direcory called lab03. Use the following commands to do this.

cd public_html

mkdir lab05

9
Logoff mathcssun.

10
Using an ftp client, log onto your account on mathcssun. Copy the files from the mypage directory to your lab05 directory on mathcssun.

11
Close the ftp client.

12
View your new page on mathcssun using the Netscape browser. The address of your page will be something like: http://mathcssun.emporia.edu/~yourUserId/lab05/lab05.html.

13
Print out new web page. This is what you will turn in for this assignment.

Modify your main web page contained in the file index.html to include a link to this new page. In the section in your home page called laboratory assignments include this link here.

1	Create a directory called *mypage* in the temp directory on the computer. Put all your work here.
2	Gather up the image. It is already in .jpg format which is compatable with the digitizer.
3	Download the digitizer and install it. It is available here or locally here.
4	Read the documentation for the digitizer. Use the digitizer to obtain the data points and save them in your temporary directory.
5	Import the data points into Microsoft Excel. Hint: When doing the multiple regression analysis you will need to create an array in which to display the results. To do this highlight a sufficient number of cells to display the results from linest. Enter the parameters for the linest function and then hit <ctrl><shift><enter> simulatanously to fill the array with the results.
6	Using the Visual Page editor create a web page that summarizes all the analysis. Call this page lab05.html. Be sure to included a statistical summary, plots and a narrative that describes the analysis performed.
7	Using a telnet client, log onto mathcssun.
8	In your public_html directory create a direcory called lab03. Use the following commands to do this. cd public_html mkdir lab05
9	Logoff mathcssun.
10	Using an ftp client, log onto your account on mathcssun. Copy the files from the mypage directory to your lab05 directory on mathcssun.
11	Close the ftp client.
12	View your new page on mathcssun using the Netscape browser. The address of your page will be something like: http://mathcssun.emporia.edu/~yourUserId/lab05/lab05.html.
13	Print out new web page. This is what you will turn in for this assignment.