## Question

Download the two files `zero.to.60.csv` and `quarter.mile.csv`. These are records of motorcycle performance for a standing start to 60 mph and for quarter mile time. Each table has a column identifying the make and model for each entry, but this name of the column is different for each table.

## Part a.

There are some duplicates, so compute a mean of `Time` for each motorcycle, from both tables.

## Part b.

Create a new table with these means, but use only those motorcycles that are in both tables. You will need to merge these by names.

## Part c.

Plot the relationship between 0-to-60 time and quarter mile time.

## Solution Preview

These solutions may offer step-by-step problem-solving explanations or good writing examples that include modern styles of formatting and construction of bibliographies out of text citations and references. Students may use these solutions for personal skill-building and practice. Unethical use is strictly forbidden.

## Part a.

There are some duplicates, so compute a mean of `Time` for each motorcycle, from both tables.
CODE:
proc means data=quarter;
var time;
class Motorcycle;
output out=quar_mean mean=mean_quarter;
run;

proc means data=zero;
var time;
class Make_and_model;
output out=zero_mean mean=mean_zero;
run;

/* Removing the overall mean i.e. empty Motorcycle and Make and model, keeping only two variables required and renaming the variables*/
data quar_mean;
set quar_mean;
if Motorcycle ne "";
keep Motorcycle mean_quarter;
run;

data zero_mean;
set zero_mean;
if Make_and_model ne "";
keep Make_and_model mean_zero;
run;...

By purchasing this solution you'll be able to access the following files:
Solution.docx and Solution.sas.

# 50% discount

Hours
Minutes
Seconds
\$13.00 \$6.50
for this solution

or FREE if you
register a new account!

PayPal, G Pay, ApplePay, Amazon Pay, and all major credit cards accepted.

### Find A Tutor

Get College Homework Help.

Are you sure you don't want to upload any files?

Fast tutor response requires as much info as possible.