Question
Based on social media survey data, the marketing compiled an overall rating scores for each of their bikes. The survey also contained ratings on many
Based on social media survey data, the marketing compiled an overall rating scores for each of their bikes. The survey also contained ratings on many bike components, and GBI marketing would like to assess whether a relationship exists in the scores of three relatively inexpensive bike components (brakes, handlebars, and saddle) and the overall bike scores. The idea is that these components could be swapped at little to no costs if it would improve the overall bike rating scores.
In the attached file, each score represents the percentage of respondents who rated one of the three independent components (brakes, handlebars, and saddle) as excellent or very good. The overall scores for each bike are also included in the file. For example, the highest ranked bike, the Deluxe Road Bike (Shimano), had an overall score of 94.3, and component scores of 94.5 (brakes), 90.8 (handlebars), and 97.7 (saddle).
Hotel | Overall | Brakes | Handlebars | Saddle |
Deluxe Road Bike (Shimano) | 94.3 | 94.5 | 90.8 | 97.7 |
Men's Off Road Bike Hard Tail (SRAM) | 92.9 | 96.6 | 84.1 | 96.6 |
Men's Off Road Bike Fully | 92.8 | 99.9 | 100.0 | 88.4 |
Professional Touring Bike (Campagnolo) | 91.2 | 88.5 | 94.7 | 97.0 |
Men's Off Road Bike Hard Tail | 90.4 | 95.0 | 87.8 | 91.1 |
Professional Road Bike (Shimano) | 90.2 | 92.4 | 82.0 | 98.7 |
Deluxe Touring Bike (Campagnolo) | 90.1 | 95.9 | 86.2 | 91.9 |
Women's Off Road Bike Fully | 89.8 | 92.5 | 92.5 | 88.8 |
Professional Touring Bike (SRAM) | 89.3 | 94.6 | 85.8 | 90.7 |
Deluxe Road Bike (SRAM) | 89.1 | 90.5 | 83.2 | 90.4 |
Deluxe Touring Bike (SRAM) | 89.1 | 90.8 | 81.9 | 88.5 |
Professional Touring Bike (Shimano) | 89.0 | 93.0 | 93.0 | 89.6 |
Deluxe Touring Bike (FSA) | 88.6 | 92.5 | 78.2 | 91.2 |
Professional Road Bike (Campagnolo) | 87.1 | 93.0 | 91.6 | 73.5 |
Professional Road Bike (SRAM) | 87.1 | 90.9 | 74.9 | 89.6 |
E-Bike Tailwind | 86.5 | 94.3 | 78.0 | 91.5 |
City Bike Max | 86.1 | 95.4 | 77.3 | 90.8 |
Fixed Gear Bike Plus | 86.0 | 94.8 | 76.4 | 91.4
|
Q6: What is the conclusion for the significance of each independent variable at the 0.05 level of significance? (You can refer to the p values)
Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started