The Union Cyclist Internacional (UCI) is the premier global cycling organization primarily known as the organizing body for professional cycling around the world.  Your firm has been hired by the UCI to research bicycle buying characteristics around the world.  They believe that their fan base is built from people who buy bicycles, regardless of the initial reason they make the purchase.  They are interested in identifying their fan base in order to better market and price their professional cycling merchandise and television distributorship. In addition, the UCI has other goals including to expand bicycle use around the world to reduce global warming, fight obesity, personal enjoyment, and to expand other health and mental health benefits of bicycle riding. To that end, the UCI is asking you to collect information from bicycle shop visitors, regardless of whether or not they purchase a bike or bicycle accessory.  What the organization really wants to know is, what types of people are coming into bike shops? How do we get these bike buyers to start watching UCI? Who/Where should we focus our marketing efforts? What relationships exist in the data that we can take advantage of? Are they real (significant) relationships?

 

 Hello! they gave me the following prompt and I am trying to figure it out what variables from the table use for linear regression. what do you recommend?

Transcribed Image Text:

ID Marital Status Gender Income Children. Education $ 60,000.00 $110,000.00 $ 20,000.00 14927 Married 28758 Married 27760 Single 22918 Single 15302 Single 15532 Single 18347 Single 19461 Single 19608 Married 23993 Single 20877 Single 14058 Single 23963 Married 15657 Married 14669 Married 25313 Single 12591 Married 25555 Married 23908 Single 16468 Single 17848 Single 27878 Single 16179 Single 21365 Married 27582 Single 24093 Single 20711 Married 19235 Married 16337 Married 23549 Single 15272 Single 19164 Single Female $50,000.00 Male $ 70,000.00 Female $ 40,000.00 Male $150,000.00 Female $110,000.00 Male $100,000.00 Female $30,000.00 Female $10,000.00 Male $ 90,000.00 Female $20,000.00 Male Male Male Male $ 50,000.00 Female $90,000.00 Male $ 20,000.00 Female $30,000.00 Female $10,000.00 Male Male Male Male Female $90,000.00 Female $10,000.00 Female $160,000.00 Female $80,000.00 Female $70,000.00 Female $90,000.00 Male $100,000.00 Male Male $ 40,000.00 $ 50,000.00 Female $100.000.00 $ 60,000.00 $ 40,000.00 $ 40,000.00 $ 30,000.00 1 Bachelors 2 Partial College 0 Graduate Degree 5 Graduate Degree 1 Graduate Degree 4 Bachelors 0 Partial College 4 Partial High School 5 Bachelors 0 Partial College 1 Bachelors 0 Bachelors 0 Partial High School 3 Graduate Degree 4 Graduate Degree 0 Partial High School Manual Clerical 4 Graduate Degree 0 Partial College Manual 0 Graduate Degree 1 Bachelors Occupation Home Owner Cars Commute Distance 1 Bachelors 0 Partial College 0 Partial College 0 Partial College 5 Bachelors 2 Partial High School Clerical 2 Bachelors 0 Graduate Degree 0 Partial College Clerical Clerical Clerical Management Professional Professional Skilled Manual Manual Professional Manual Clerical Professional Manual Clerical Management 0 High School 0 High School 0 Bachelors Clerical Clerical Clerical Manual Professional Professional Skilled Manual Skilled Manual Skilled Manual Skilled Manual Skilled Manual. Skilled Manual Professional Yes Yes No Yes Yes Yes No Yes Yes No Yes No No Yes Yes No Yes No No Yes No No Yes Yes No No Yes Yes No Yes No No 0 0-1 Miles 1 1-2 Miles 0 0-1 Miles 3 0-1 Miles 0 2-5 Miles 2-5 Miles 1-2 Miles 0-1 Miles 2 1 2 1-2 Miles 4 1 0-1 Miles 0 1-2 Miles 1 5-10 Miles 2 0-1 Miles 0 0-1 Miles 1 0-1 Miles 2 1-2 Miles 0-1 Miles 0 1 1 0-1 Miles 0-1 Miles 1 2-5 Miles 1 2-5 Miles 0 0-1 Miles 4 1-2 Miles 2 5-10 Miles 0 0-1 Miles 0 0-1 Miles 0 1-2 Miles 0 0-1 Miles 2 1-2 Miles 2 5-10 Miles 2 1-2 Miles 1 2-5 Miles Region Europe Europe Europe Pacific North America North America North America Europe Pacific Pacific Europe Pacific Europe Europe Pacific Europe Europe Pacific Europe Europe Europe Pacific Pacific Pacific Pacific Europe Europe North America North America North America North America North America Age Bike Owner owner Income Actual Bike Price Bike of Interest2 purchased purchase1 37 Yes 35 Yes 37 Yes No 34 Yes 43 Yes 31 No. 40 No 40 No 26 Yes 37 Yes 41 Yes 33 No. 46 Yes 36 No 35 No 1 $ 53,206.89 $1,528.61 Cruiser 1 $ 79,346.07 $ 787.92 Cruiser 1 $ 46,126.45 $1,668.20 Cruiser 0 $ 151,908.15 $882.15 Cruiser 1 $ 113,537.28 $ 716.28 Cruiser 1 $ 108,809.03 $1,629.07 Cruiser 0 $ 38,659.72 $ 716.28 Cruiser 0 $ 15,510.33 $ 816.63 Mountain Bike 0 $ 94,362.12 $1,078.85 Mountain Bike 1 $ 20,658.08 $2,177.83 Mountain Bike 1 $ 60,976.19 $2,457.81 Mountain Bike 1 $ 117,929.15 $1,177.35 Mountain Bike 0 $ 20,355.40 $2,028.65 Mountain Bike 1 $ 59,345.23 $1,508.77 Mountain Bike 0 $ 96,058.99 $2,079.64 Mountain Bike 0 $ 20,088.58 $2,064.51 Mountain Bike 0 $ 34,257.35 $1,158.07 Mountain Bike 1 $ 17,112.82 $1,284.70 Mountain Bike 1 $ 61,318.57 $ 809.22 Mountain Bike 0 $ 46,123.61 $2,152.89 Mountain Bike 1 $ 43,311.51 $2,906.03 Mountain Bike 1 $ 34,583.24 $1,470.50 Mountain Bike 0 $ 98,401.31 $1,639.07 Mountain Bike 0 $ 11,538.03 $1,430.13 Mountain Bike 1 $ 167,257.09 $1,984.30 Mountain Bike 1 $ 87,855.88 $2,948.97 Mountain Bike 1 $ 77,740.85 $ 739.48 Mountain Bike 0 $ 97,420.26 $3,280.63 Mountain Bike 0 $ 108,823.21 $2,369.28 Mountain Bike $1,743.49 Mountain Bike $1,995.06 Mountain Bike $2.827.11 Mountain Bike 45 No 26 Yes 39 Yes 30 No 31 Yes 28 Yes 38 No 58 No 36 Yes 40 Yes 32 Yes 34 No 29 No 30 No 30 No 38 Yes 0 $ 41,679.05 0 $ 55,408.90 1 $ 107.562.01 yes yes no. no ves no no no no no no. yes no no no no no no no yes no. no no yes yes yes yes yes no. no yes no 1 1 0 0 1 0 0 0 0 0 0 1 0 0 0 0 0 0 0 1 0 0 0 1 1 1 1 1 0 0 1 0 ID Marital Status Gender Income Children. Education $ 60,000.00 $110,000.00 $ 20,000.00 14927 Married 28758 Married 27760 Single 22918 Single 15302 Single 15532 Single 18347 Single 19461 Single 19608 Married 23993 Single 20877 Single 14058 Single 23963 Married 15657 Married 14669 Married 25313 Single 12591 Married 25555 Married 23908 Single 16468 Single 17848 Single 27878 Single 16179 Single 21365 Married 27582 Single 24093 Single 20711 Married 19235 Married 16337 Married 23549 Single 15272 Single 19164 Single Female $50,000.00 Male $ 70,000.00 Female $ 40,000.00 Male $150,000.00 Female $110,000.00 Male $100,000.00 Female $30,000.00 Female $10,000.00 Male $ 90,000.00 Female $20,000.00 Male Male Male Male $ 50,000.00 Female $90,000.00 Male $ 20,000.00 Female $30,000.00 Female $10,000.00 Male Male Male Male Female $90,000.00 Female $10,000.00 Female $160,000.00 Female $80,000.00 Female $70,000.00 Female $90,000.00 Male $100,000.00 Male Male $ 40,000.00 $ 50,000.00 Female $100.000.00 $ 60,000.00 $ 40,000.00 $ 40,000.00 $ 30,000.00 1 Bachelors 2 Partial College 0 Graduate Degree 5 Graduate Degree 1 Graduate Degree 4 Bachelors 0 Partial College 4 Partial High School 5 Bachelors 0 Partial College 1 Bachelors 0 Bachelors 0 Partial High School 3 Graduate Degree 4 Graduate Degree 0 Partial High School Manual Clerical 4 Graduate Degree 0 Partial College Manual 0 Graduate Degree 1 Bachelors Occupation Home Owner Cars Commute Distance 1 Bachelors 0 Partial College 0 Partial College 0 Partial College 5 Bachelors 2 Partial High School Clerical 2 Bachelors 0 Graduate Degree 0 Partial College Clerical Clerical Clerical Management Professional Professional Skilled Manual Manual Professional Manual Clerical Professional Manual Clerical Management 0 High School 0 High School 0 Bachelors Clerical Clerical Clerical Manual Professional Professional Skilled Manual Skilled Manual Skilled Manual Skilled Manual Skilled Manual. Skilled Manual Professional Yes Yes No Yes Yes Yes No Yes Yes No Yes No No Yes Yes No Yes No No Yes No No Yes Yes No No Yes Yes No Yes No No 0 0-1 Miles 1 1-2 Miles 0 0-1 Miles 3 0-1 Miles 0 2-5 Miles 2-5 Miles 1-2 Miles 0-1 Miles 2 1 2 1-2 Miles 4 1 0-1 Miles 0 1-2 Miles 1 5-10 Miles 2 0-1 Miles 0 0-1 Miles 1 0-1 Miles 2 1-2 Miles 0-1 Miles 0 1 1 0-1 Miles 0-1 Miles 1 2-5 Miles 1 2-5 Miles 0 0-1 Miles 4 1-2 Miles 2 5-10 Miles 0 0-1 Miles 0 0-1 Miles 0 1-2 Miles 0 0-1 Miles 2 1-2 Miles 2 5-10 Miles 2 1-2 Miles 1 2-5 Miles Region Europe Europe Europe Pacific North America North America North America Europe Pacific Pacific Europe Pacific Europe Europe Pacific Europe Europe Pacific Europe Europe Europe Pacific Pacific Pacific Pacific Europe Europe North America North America North America North America North America Age Bike Owner owner Income Actual Bike Price Bike of Interest2 purchased purchase1 37 Yes 35 Yes 37 Yes No 34 Yes 43 Yes 31 No. 40 No 40 No 26 Yes 37 Yes 41 Yes 33 No. 46 Yes 36 No 35 No 1 $ 53,206.89 $1,528.61 Cruiser 1 $ 79,346.07 $ 787.92 Cruiser 1 $ 46,126.45 $1,668.20 Cruiser 0 $ 151,908.15 $882.15 Cruiser 1 $ 113,537.28 $ 716.28 Cruiser 1 $ 108,809.03 $1,629.07 Cruiser 0 $ 38,659.72 $ 716.28 Cruiser 0 $ 15,510.33 $ 816.63 Mountain Bike 0 $ 94,362.12 $1,078.85 Mountain Bike 1 $ 20,658.08 $2,177.83 Mountain Bike 1 $ 60,976.19 $2,457.81 Mountain Bike 1 $ 117,929.15 $1,177.35 Mountain Bike 0 $ 20,355.40 $2,028.65 Mountain Bike 1 $ 59,345.23 $1,508.77 Mountain Bike 0 $ 96,058.99 $2,079.64 Mountain Bike 0 $ 20,088.58 $2,064.51 Mountain Bike 0 $ 34,257.35 $1,158.07 Mountain Bike 1 $ 17,112.82 $1,284.70 Mountain Bike 1 $ 61,318.57 $ 809.22 Mountain Bike 0 $ 46,123.61 $2,152.89 Mountain Bike 1 $ 43,311.51 $2,906.03 Mountain Bike 1 $ 34,583.24 $1,470.50 Mountain Bike 0 $ 98,401.31 $1,639.07 Mountain Bike 0 $ 11,538.03 $1,430.13 Mountain Bike 1 $ 167,257.09 $1,984.30 Mountain Bike 1 $ 87,855.88 $2,948.97 Mountain Bike 1 $ 77,740.85 $ 739.48 Mountain Bike 0 $ 97,420.26 $3,280.63 Mountain Bike 0 $ 108,823.21 $2,369.28 Mountain Bike $1,743.49 Mountain Bike $1,995.06 Mountain Bike $2.827.11 Mountain Bike 45 No 26 Yes 39 Yes 30 No 31 Yes 28 Yes 38 No 58 No 36 Yes 40 Yes 32 Yes 34 No 29 No 30 No 30 No 38 Yes 0 $ 41,679.05 0 $ 55,408.90 1 $ 107.562.01 yes yes no. no ves no no no no no no. yes no no no no no no no yes no. no no yes yes yes yes yes no. no yes no 1 1 0 0 1 0 0 0 0 0 0 1 0 0 0 0 0 0 0 1 0 0 0 1 1 1 1 1 0 0 1 0

Answer rating: 100% (QA)

Here are some recommendations for variables to use in linear regression models to answer the questions posed by the UCI Dependent variable WatchUCI whether the individual watches UCI races Independent... View the full answer