Lab 2 Worksheet

Psych 248 — Lab 2 Descriptive Statistics
Name: Griffin Kearney, Hannah Cummings, Jefferson Bellevue
This assignment will give you practice working with an existing data file, entering a new data file, and creating
descriptive statistics. You may work in pairs during lab but both should turn in this worksheet at the end for lab credit.
Part A. OPEN AN EXISTING SPSS DATA FILE.

Open the SPSS data file called Sales.sav (located on K drive under Psych248 folder).
Look at the data file—both in data view and variable view windows.
[Control-End will take you to the bottom of the file & Control-Home will take you back to the top]
1. How many variables are there? ____6_____ How many cases are there? ___1,500_____
2. What are the value labels for Industry variable? 1 = Government 2 = Commercial 3 = Academic
3. Which variable is scale/ratio measure? ID and Revenue
4. Why is Support classified “ordinal” whereas Region and Industry are nominal measures?
The support section is classified as ordinal due to the fact that it has a ranking system using names (they can be put
into an order). The Region and Industry sections are nominal because they cannot be put into order, region displays
directional terms and industry displays three government systems.
Create frequency distribution tables and bar graphs for customer, support, region, & industry variables.
 Go to Analyze  Descriptive Stats  Frequencies then select the 4 variables.
 Make sure the Display frequency table box is checked. Under Statistics – leave all boxes unchecked.
 Under Charts; Select Bar chart as Chart Type AND Select Frequencies under Chart Values.
5. Why would it make no sense to compute a mean or standard deviation for these variables?
There should not be a mean or standard deviation for these variables due to the fact that they do not contain numbers.
6. What percentage of customers was left on hold less than one minute? 18.6%
7. What percentage of customers was kept on hold for more than 4 minutes? 37.5%
Create a table of descriptive statistics and a histogram with a normal curve for revenue variable (the only meaningful
ratio-level variable).
 Go to Analyze, Descriptive Statistics, Frequencies. Remove previous variables and select revenue.
 Uncheck box that says Display frequency table.
 Click Statistics – Check standard deviation, minimum, maximum, mean, median, mode, and skewness.
 Under Charts select histogram and check the box to Show normal curve on histogram.
8. Does revenue appear to be fairly normally distributed? How can you tell from the stats & histogram?
The graph appears to be normally distributed due to the fact that it is unimodal and evenly distributed.
9. What does skewness mean?

Skewness defines whether the tail of a graph is facing towards the left or the right of the graph.
Another useful way to summarize data is to break down a continuous variable (e.g. revenue) by a categorical or nominal
variable of interest (e.g., region, customer type).
 Go to Analyze  Descriptive Statistics  Explore. Select revenue as the DV AND region as the Factor.
 Under Statistics select Descriptives. Under Plots select Histogram and Boxplots (factor levels together).
10. Which is the only region that does not have outliers (extreme values) at the high end of the scale? West
11. Do you think the medians and amount of variability in revenue are similar across regions? Justify your answer.
Yes, the medians of the revenue for each region only differ by a max of $134 and the amount of variability is also
extremely similar.
Create a means table for revenue to answer Q#12.

 Use Analyze  Compare Means  Means.
 Select revenue as DVs and customer as IV.
12. One might predict that preferred customers are bigger spenders than regular customers. Is this hypothesis supported in
the data? Explain your answer.
This hypothesis cannot be proven by the data due to the fact that regular customers on average spend more than the
preferred customers.
Create a cross-tabulation for support (time on hold) by customer status to answer Q#13.
 Go to Analyze  Descriptives  Crosstabs. Put customer status in rows and Support in columns.
 Click on Cells and click on row percentages.
13. One might predict that preferred customers receive better treatment when they need help (technical support) from the
company. Is this hypothesis supported in the data? Explain your answer.
This hypothesis does not stand, as being a preferred customer does not guarantee better technical support. On average,
the regular customer is spending less amount of time on hold.
Professor Robinson approved our data sheet for Part B and instructed us to not answer the questions.
Part B: CREATING A NEW DATA FILE AND EXAMINING RELATIONSHIPS.

The following data represent the results of descriptive research on the ability to solve mazes in preschool children. The
researchers tested 60 children with the same maze, and recorded the number of errors each child made while solving it.
Each child’s age and gender were also recorded.
4-year-old girls: 12, 9, 13, 7, 10, 8, 11, 9, 10, 12 4-year-old boys: 9, 13, 14, 11, 9, 9, 10, 8, 7, 10
Input these data into SPSS data window.

 Think about IVs and DVs and create proper variables for each aspect of the given data. Generate a frequency
table for the DV (error score). Obtain the mean, median, mode, SD, skewness, kurtosis.
 Obtain a histogram with a normal curve superimposed on it.
1. What kind of distribution does the dependent variable have? ___________________
Obtain descriptive statistics and a histogram for error variable separately for girls and boys using gender as a factor.
2. How do girls compare to boys in terms of the number of errors?
Generate a scatterplot and side by side boxplots using age as an explanatory variable (X axis) and number of errors
as an outcome variable (Y axis). [Hint: Set age as an ordinal measure. Create the boxplots and scatterplot by going
to Graphs  Chart Builder]
3. Do age groups seem to be different from one another in terms of the number of errors? (Explain)

Lab 2 Worksheet

Uploaded by

Copyright:

Available Formats

Lab 2 Worksheet

Uploaded by

Document Information

Original Title

Copyright

Available Formats

Share this document

Share or Embed Document

Sharing Options

Did you find this document useful?

Is this content inappropriate?

Copyright:

Available Formats

Lab 2 Worksheet

Uploaded by

Copyright:

Available Formats

Psych 248 — Lab 2 Descriptive Statistics

Name: Griffin Kearney, Hannah Cummings, Jefferson Bellevue

Part A. OPEN AN EXISTING SPSS DATA FILE.

9. What does skewness mean?

Create a means table for revenue to answer Q#12.

Part B: CREATING A NEW DATA FILE AND EXAMINING RELATIONSHIPS.

Input these data into SPSS data window.

You might also like