EssayNest

# Instructions: 1. Refer to the spreadsheet on Excel that contains the variables “weekly assignment…

Get your original paper written from scratch starting at just \$10 per page with a plagiarism report and free revisions included!

4.8

SiteJabber

4.9

ResellerRatings

4.9

Reviews.io

Hire A Writer

Instructions:

1. Refer to the spreadsheet on Excel that contains the variables “weekly assignment 9 stat. data spreadsheet”.

2. Use Excel statistics tools (see instructions for excel 2003 and 2007 below. For excel 2010 and above go to the internet and find instructions)

3. Obtain:

descriptive statistics for interval variables/questions 1, 2, 3, 4, 5, 6, 7, and 9

correlations between interval variables above

regression for question 1 as the dependent variable and questions 2, 3, 4, 5, 6, 7 and 9 as independent variables.

Print the resulting tables

4. For nominal variables 8, 10, 11, 12, and 13:

Obtain counts (use “COUNTIF” function)

Construct a table of counts for each nominal variable

Construct a pie chart from the table for each nominal variable

Print the resulting tables and pie charts

Copy all tables and pie charts from Excel and paste them into your Research Document

This is the survey used for this assignment and the data is on the excel sheet attached below

Charts in Excel 2007

Pie Chart

1. Click on ‘Insert’ tab (along top)

2. Click on ‘Pie’ chart, then 3-D Pie

3. Chart data range (at top of new window), minimize

4. Select your data (labels and values only)

5. Maximize ‘Select Data Source’/OK

6. Click on Layout tab (along top)

7. In ‘Labels’ section:

• click Data Labels/More Data Label Options (bottom of menu)/check Category Name, Value, Percentage, Show Leader Lines/Close

• click Legend, click None

• click on Chart Title/Above Chart – type in your title in the text box

8. Click and drag each Data label text box for appropriate appearance

9. Click just outside the pie chart to select the pie – drag the box that appears to resize the pie and to move around within the chart.

10. Click on any sector to format that sector, i.e., change color, fill, lines, etc

Statistics on Excel

To enter a data sheet:

Open Excel

Type in data in individual cells – normally cases go down (rows) and individual variables across (columns)

To input a formula (or perform a calculation):

Highlight any cell into which you wish to place a formula

Click on equal sign on formula bar

Click on specific cells (or type in cell address) you wish to include in the formula along with appropriate operation sign in appropriate order

Click OK

To obtain Descriptive Statistics:

2003

Click on Tools/Data Analysis/

Click on Descriptive Statistics/OK (if ‘Data Analysis’ does not appear, click on Add-ins, check Analysis Toolpak, Analysis Toolpak VBA, OK) and re-click on Tools)

Input Range – click red minimize icon on right; highlight range of data under consideration; click red maximize icon on right

If a label is in the top cell of the data column, check ‘Label in First Row’ box

Check ‘Summary Statistics’

Check ‘Confidence Interval’ (insure ‘95’ or appropriate interval)

Check ‘New Worksheet’

Click OK – Statistics appear on a new sheet which can be copied to the original data sheet

2007