1 / 5

Lab 1: Make A Scatter Plot of Data with Error Bars

Lab 2: Determine whether data set differences are statistically significant.. The second worksheet contains the data from Lab 1.Compute the standard score (Z) for the differences between each data set.Which of the data points cannot be shown to be different from the others with 95% confidenc

arkadiy
Download Presentation

Lab 1: Make A Scatter Plot of Data with Error Bars

An Image/Link below is provided (as is) to download presentation Download Policy: Content on the Website is provided to you AS IS for your information and personal use and may not be sold / licensed / shared on other websites without getting consent from its author. Content is provided to you AS IS for your information and personal use only. Download presentation by click this link. While downloading, if for some reason you are not able to download a presentation, the publisher may have deleted the file from their server. During download, if you can't get a presentation, the file might be deleted by the publisher.

E N D

Presentation Transcript

    1. Lab 1: Make A Scatter Plot of Data with Error Bars Open c:\StatsLab.xls In sheet 1 is some data. Use the function =average() and =stdev to put the means and standard deviations where they are indicated. Make a scatter plot of the means versus the dependent variable, the quantity of fertilizer. Add error bars of 2s.

    2. Lab 2: Determine whether data set differences are statistically significant. The second worksheet contains the data from Lab 1. Compute the standard score (Z) for the differences between each data set. Which of the data points cannot be shown to be different from the others with 95% confidence?

    3. Lab 3: Students T-Test In Lab 3, another, much smaller data set from another fertilizer is to be analyzed. Can it be concluded that the other fertilizer had a statistical effect on the growth?

    4. Lab 4: Determining Correlation Make a scatter plot of the hours studied versus exam score columns. Find the correlation coefficient by using the function >Insert >Function >Statistical >Pearson Plot the linear least squares fit of the plot and the r2 value on the graph. Determine how confident we can be that the phenomena are linked.

    5. Lab 5: ?2 Analysis Wally likes to fish, rain or shine. Some days he catches fish and other days he doesnt. Find out if there is a link between rainy days and Wallys luck with the rod and reel. What is the probability of such an event occurring by accident?

More Related