Problem Description:
The SPSS analysis assignment aimed to analyze bicycling habits in Canada based on a dataset collected over the last 3 months. The focus was on understanding the frequency, duration, and preferences related to bicycling.
Part 1: General Trends
- Answer 1-B:
- Answer 2-C:
Part 2: Specific Variables Analysis
Variable - PAC_1D
Act./last 3 mo - Bicycling
- Valid Responses: 60,239
- Missing Responses: 1,468
| Response | Frequency | Percent | Valid Percent | Cumulative Percent |
|---|---|---|---|---|
| YES | 12,850 | 20.8 | 21.3 | 21.3 |
| NO | 47,389 | 76.8 | 78.7 | 100.0 |
Missing Responses Breakdown:
- DON'T KNOW: 27
- REFUSAL: 30
- NOT STATED: 1,411
Insights: Only 20.8% have bicycled in the last 3 months.
Variable - PAC_2D
No. of Times - Bicycling
- Valid Responses: 12,728
| Statistics | Value |
|---|---|
| Minimum | 1 |
| Maximum | 200 |
| Mean | 20.16 |
| Std. Deviation | 25.505 |
| Variance | 650.520 |
Insights: On average, Canadians bicycled around 20.16 times in the last 3 months.
Variable - PAC_3D
Time Spent - Bicycling
- Valid Responses: 12,691
- Missing Responses: 49,016
| Time Spent | Frequency | Percent | Valid Percent | Cumulative Percent |
|---|---|---|---|---|
| 1 TO 15 MINUTES | 1,046 | 1.7 | 8.2 | 8.2 |
| 16 TO 30 MINUTES | 3,867 | 6.3 | 30.5 | 38.7 |
| 31 TO 60 MINUTES | 4,557 | 7.4 | 35.9 | 74.6 |
| MORE THAN 1 HOUR | 3,221 | 5.2 | 25.4 | 100.0 |
Missing Responses Breakdown:
- NOT APPLICABLE: 47,389
- DON'T KNOW: 36
- REFUSAL: 1
- NOT STATED: 1,590
Insights: Most Canadians bicycled for 31-60 minutes per session (7.4%).
Overall Analysis:
- Only 20.8% of respondents have bicycled in the last 3 months.
- On average, Canadians bicycled around 20.16 times in the last 3 months with a standard deviation of 25.505.
- The majority (7.4%) spent 31-60 minutes bicycling per session.