Project #70896 - statistics

Lesson 9: Using Excel to Perform Statistical Tests - Assignment 9.1



 

Performing Statistical Calculations Using Excel

OBJECTIVES

  • Enter data into Excel
  • Learn to use the functions of Excel
  • Use Excel to calculate and interpret means, standard deviations, and z-Scores
  • Use Excel to calculate and interpret t, F, and r

ASSIGNMENT OVERVIEW

This assignment explores using a software program (such as MS Excel) to perform calculations and determine relationships between variables.

DELIVERABLES

Answers to exercise questions.

Step 1 Complete the following tasks.

Perform the following activities using a program such as MS Excel. Keep all calculations within one file. You may use separate worksheets within the same file, though.

    1. Open a worksheet and enter in the following data:

Years of
Education
Expenditures
on Books
13 5
17 45
9 0
11 18
15 25
12 4
13 10
18 35
16 15
10 0

      1. Using this data, report the descriptive statistics for each variable. Report the mean and the standard deviation for each variable.
      2. Determine if there is a relationship between the two variables. Be sure to determine if the relationship is significant.
      3. Using this same data, report the regression equation that could be used to make predictions about the amount of money spent on books when the number of years of education is known.
    1. You are a researcher who is interested in studying the effects of Prozac on children. You equally divide 40 young rats into two groups: one that receives no Prozac and one group that receives one dose of Prozac. You want to determine if there is a significant effect of Prozac on learning and memory. You collect the number of errors on a task for each subject, which is listed below. Higher numbers of errors indicate lower levels of learning and memory. You analyze the data using a software program to determine if groups are significantly different from one another.

Control Group Prozac Group
5 12
2 7
6 10
3 12
2 14
5 10
3 9
1 11
2 6
1 11
2 9
7 11
3 11
5 12
5 15
4 10
3 12
5 12
4 11
5 6

Subject Mathematics
Due By (Pacific Time) 05/13/2015 11:00 pm
Report DMCA
TutorRating
pallavi

Chat Now!

out of 1971 reviews
More..
amosmm

Chat Now!

out of 766 reviews
More..
PhyzKyd

Chat Now!

out of 1164 reviews
More..
rajdeep77

Chat Now!

out of 721 reviews
More..
sctys

Chat Now!

out of 1600 reviews
More..
sharadgreen

Chat Now!

out of 770 reviews
More..
topnotcher

Chat Now!

out of 766 reviews
More..
XXXIAO

Chat Now!

out of 680 reviews
More..
All Rights Reserved. Copyright by AceMyHW.com - Copyright Policy