Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

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

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Horngrens Accounting Volume 1

Authors: Tracie Miller Nobles, Brenda Mattison, Ella Mae Matsumura, Carol Meissner, JoAnn Johnston, Peter Norwood

11th Canadian Edition

0135359708, 9780135359709

More Books

Students also viewed these Accounting questions

Question

ineed car rental system project oracle apex

Answered: 1 week ago

Question

Did you print a proof to view color and image consistency?

Answered: 1 week ago