Access over 20 million homework & study documents
search

W6 lecture creating graphs using microsoft excel

Content type

User Generated

School

South University

Rating

Showing Page:
1/5

Sign up to view the full document!

lock_open Sign Up
Showing Page:
2/5

Sign up to view the full document!

lock_open Sign Up
Showing Page:
3/5

Sign up to view the full document!

lock_open Sign Up
End of Preview - Want to read all 5 pages?
Access Now

Unformatted Attachment Preview

Creating Graphs using Microsoft Excel Microsoft Excel can be used to create bar graphs, line graphs, and scatterplots using selected parts of the output. You will also learn to create histograms, which will be useful in interpreting the data for OLS and BMS students. CREATING HISTOGRAMS using MICROSOFT EXCEL With data measured on a continuous scale, you want the bars touching, which pictorially represents the continuous nature of the data. For this, you need a histogram. 1. For the Histogram, it is first necessary to set up BIN numbers. These number define the values included in each bar. In the example below, the bin number 50 tells Microsoft Excel to include all values between 50 and 60; 60 tells Microsoft Excel to include all values between 60 and 70, and so forth. 2. The next step is to create the histogram itself. Click Data, click Data Analysis, and select Histogram. 3. Click OK a. Enter the Input Range of values to be plotted on the Histogram b. Enter the range that contains your BIN c. Check Labels d. Enter a cell number to place your output e. Check Chart Output 4. Click OK a. You are given a Frequency Distribution, which tells you how many of each different score is included in your distribution. b. You are also given the chart itself. 5. Change the title on your chart to include the name of the variable that was graphed: Histogram of BMS Frequency 6 4 2 Frequency 0 50 60 70 80 90 100 More BIN 6. Repeat these steps for each variable you need to gr ...
Purchase document to see full attachment
User generated content is uploaded by users for the purposes of learning and should be used following Studypool's honor code & terms of service.

Anonymous
Great! 10/10 would recommend using Studypool to help you study.

Studypool
4.7
Trustpilot
4.5
Sitejabber
4.4