Case Summary Analysis With IBM SPSS

Introduction

In this article, we are going to explore how to use IBM SPSS to summarize or gain insight into one or more scale variables, this summarize operation generates report tables with summary statistics and/or specific case listings automatically without errors. For variables inside categories of one or more grouping variables, the case summaries technique generates subgroup statistics. The grouping variable is cross-tabulated at every level. 

However, there are several different statistics that can be used to express central tendency and dispersion. A categorical variable's levels can be used to produce statistics and case displays, which may contain all observations or only a subset of them. The wording for blank cells, footnotes, and table titles may all be readily modified to your preferences.

Related analyses are: Exploratory Data Analysis and Factor Analysis

Real-Life Scenarios

A customer of a real estate agent is selling his house. She wants to write a summary report for the customer after first gathering data on all residences sold in the neighborhood during the previous year.

Data

The market_data is used in this example to create a table with summary data on home sales, organized by the street where the house is situated, using Summarize.

In the above data, the address and street measures are both nominal and the rest of the variable measures are scale

Data Processing and Analysis

Pick the following from the options to start the analysis: Analyze => Case Summaries => Reports. Which will create a group summary report.

Figure 1: Selecting Report in Analyze options

Select the variable to be summarized as Purchase Price. Select the grouping variable House Street.

Individual case listings are not necessary for this report because it is an aggregated overview, Deselect Cases.

Figure 2: Selecting the variable and grouping variable

for display Choose Statistics. As the cell statistics, pick Mean, Median, Minimum, and Maximum. Note that Number of Cases is displayed in that list by default. In the Summarize Cases dialog box, click Options after selecting Continue.

Figure 3: Selecting the summary statistics needed

As the title, type Home Sale Statistics. Type Street is used as the caption grouping. Then click Next. In the Summarize Cases dialog box, click OK.

Figure 4: Table title and caption

Data Interpretation

The personalized title is centered above the table in bold type. The table's bottom left corner contains a footnote with the caption.

In the order they were requested, the data are shown for each street: N, Mean, Median, Minimum, and Maximum are the case numbers.

Figure 5: Summary Statistics for Sales

The seller has set a minimum value of $335,000 on his house based on a property assessment. He requests that the realtor provide him a list of the nearby properties that have sold for that amount or more, along with information on how long it took to sell each one. The realtor can choose the pertinent cases and generate this report using Summarize.

The initial step is to only choose properties selling for $335,001 or higher. Select from the Data Editor menus: Data = > Choose Cases as shown in figure 5, below. Choose If the condition is met. If, click as shown in figure 6.

Figure 6: Select the case for the data

Decide on the purchase price. The variable name, value, has been placed in the Expression section, as we can see. On the calculator pad, click ">=". Type 335000 to finish the phrase. To continue, click. In the Select Cases dialog box, click OK.

Figure 7: Entering the condition under observation

Sort the chosen properties next based on price and days on the market. The Summarize table's case listings will be arranged in this sequence. From the options in the Data Editor, select: to sort the data. Cases => Sort Data

Figure 8: To sort the case under Observation

Choose the Purchase Price as the primary factor to sort by. Choose Descending as the sort of direction. The second variable should be Days on Market Before Sold. Keep in mind that it will also be arranged in decreasing order. Click "OK."

Figure 9 : Selecting and sorting by days and purchase pric

Recall the Summarize Cases dialog box to produce the report. To return to the default settings, click Reset. Choose the variables Complete Address, Purchase Price, and Days on Market Before Sold.

Turn off "Limit cases to first." Choose Statistics

Figure 10: Creating Summary report

Determine the cell statistics by choosing Mean and Median. Keep in mind that Number of Cases was already on that list. To continue, click. In the Summarize Cases dialog box, click Options.

Figure 11: Choosing a summary report

Set the title to Case Listing. Only properties selling for $335,000 or more should be typed in the caption.

As the string to substitute for missing values, enter Unavailable.

Figure 12: Table Title

The requested statistics are always displayed below the case listing in Summarize, with cases always displayed in data file order.

• The two-level sort causes the instances to be arranged from most costly to least expensive, and within that range, from longest to shortest time on the market.

• The red column in table 1 shows the days on the Market Before the client's attention  was caught the most then the two houses sold quickly—one in a matter of days and the other in approximately three; the rest took considerably longer. Both the median and mean are little more than two months.

Case 14's Days on the Market Before Sold column is blank, hence Unavailable is displayed in Table 1 line 14.

Table 1: Summary Statistics

Conclusion

We produced a helpful overview of local house selling prices over the previous year using Case Summary Technique. Using the information from this report, we developed a case listing of homes with comparable prices and the number of days they were on the market before selling.

Practically, this report helped the realtor determine a sale price. With the aid of this new study, the seller will be able to determine if he can afford to wait for his home to sell in this market or whether he should think about reducing the price in the pursuit of a quicker transaction.

However, in SPSS there are many ways to carry out a summary analysis of data and the other options can be found in: Analyze>>>Descriptive Statistics.

← Back