Need solution for the below questions in SAS

Below is the cereals dataset and use SAS to perform the following.

a) We are interested in predicting nutrition rating based on sodium content. Construct the

appropriate scatter plot.

b) Based on the scatter plot, is there strong evidence of a linear relationship between the

variables.

c) Perform the appropriate regression.

d) Which cereal is an outlier?

e) What is the typical error in predicting rating based on sodium content?

f) Interpret the y- intercept.

g) Is there a significant relationship between the two variables? Why?

h) What is the meaning of the slope?

i) Construct a 95% confidence interval for the average nutrition rating of all cereals with sodium

content of 100

j) Construct a 95% confidence interval for the nutrition rating for a randomly chosen cereal with

sodium content of 100

CEREAL_DATASET:

Name,mfr,type,calories,protein,fat,sodium,fiber,carbo,sugars,potass,vitamins,shelf,weight,cups,rating

100%_Bran,N,C,70,4,1,130,10,5,6,280,25,3,1,0.33,68.403

100%_Natural_Bran,Q,C,120,3,5,15,2,8,8,135,0,3,1,1,33.9837

All-Bran,K,C,70,4,1,260,9,7,5,320,25,3,1,0.33,59.4255

All-Bran_with_Extra_Fiber,K,C,50,4,0,140,14,8,0,330,25,3,1,0.5,93.7049

Almond_Delight,R,C,110,2,2,200,1,14,8,-1,25,3,1,0.75,34.3848

Apple_Cinnamon_Cheerios,G,C,110,2,2,180,1.5,10.5,10,70,25,1,1,0.75,29.5095

Apple_Jacks,K,C,110,2,0,125,1,11,14,30,25,2,1,1,33.1741

Basic_4,G,C,130,3,2,210,2,18,8,100,25,3,1.33,0.75,37.0386

Bran_Chex,R,C,90,2,1,200,4,15,6,125,25,1,1,0.67,49.1203

Bran_Flakes,P,C,90,3,0,210,5,13,5,190,25,3,1,0.67,53.3138

Cap'n'Crunch,Q,C,120,1,2,220,0,12,12,35,25,2,1,0.75,18.0429

Cheerios,G,C,110,6,2,290,2,17,1,105,25,1,1,1.25,50.765

Cinnamon_Toast_Crunch,G,C,120,1,3,210,0,13,9,45,25,2,1,0.75,19.8236

Clusters,G,C,110,3,2,140,2,13,7,105,25,3,1,0.5,40.4002

Cocoa_Puffs,G,C,110,1,1,180,0,12,13,55,25,2,1,1,22.7364

Corn_Chex,R,C,110,2,0,280,0,22,3,25,25,1,1,1,41.445

Corn_Flakes,K,C,100,2,0,290,1,21,2,35,25,1,1,1,45.8633

Corn_Pops,K,C,110,1,0,90,1,13,12,20,25,2,1,1,35.7828

Count_Chocula,G,C,110,1,1,180,0,12,13,65,25,2,1,1,22.3965

Cracklin'_Oat_Bran,K,C,110,3,3,140,4,10,7,160,25,3,1,0.5,40.4488

Cream_of_Wheat_(Quick),N,H,100,3,0,80,1,21,0,-1,0,2,1,1,64.5338

Crispix,K,C,110,2,0,220,1,21,3,30,25,3,1,1,46.8956

Crispy_Wheat_&_Raisins,G,C,100,2,1,140,2,11,10,120,25,3,1,0.75,36.1762

Double_Chex,R,C,100,2,0,190,1,18,5,80,25,3,1,0.75,44.3309

Froot_Loops,K,C,110,2,1,125,1,11,13,30,25,2,1,1,32.2076

Frosted_Flakes,K,C,110,1,0,200,1,14,11,25,25,1,1,0.75,31.436

Frosted_Mini-Wheats,K,C,100,3,0,0,3,14,7,100,25,2,1,0.8,58.3451

"Fruit_&_Fibre_Dates,_Walnuts,_and_Oats",P,C,120,3,2,160,5,12,10,200,25,3,1.25,0.67,40.917

Fruitful_Bran,K,C,120,3,0,240,5,14,12,190,25,3,1.33,0.67,41.0155

Fruity_Pebbles,P,C,110,1,1,135,0,13,12,25,25,2,1,0.75,28.0258

Golden_Crisp,P,C,100,2,0,45,0,11,15,40,25,1,1,0.88,35.2524

Golden_Grahams,G,C,110,1,1,280,0,15,9,45,25,2,1,0.75,23.804

Grape_Nuts_Flakes,P,C,100,3,1,140,3,15,5,85,25,3,1,0.88,52.0769

Grape-Nuts,P,C,110,3,0,170,3,17,3,90,25,3,1,0.25,53.371

Great_Grains_Pecan,P,C,120,3,3,75,3,13,4,100,25,3,1,0.33,45.8117

Honey_Graham_Ohs,Q,C,120,1,2,220,1,12,11,45,25,2,1,1,21.8713

Honey_Nut_Cheerios,G,C,110,3,1,250,1.5,11.5,10,90,25,1,1,0.75,31.0722

Honey-comb,P,C,110,1,0,180,0,14,11,35,25,1,1,1.33,28.7424

Just_Right_Crunchy__Nuggets,K,C,110,2,1,170,1,17,6,60,100,3,1,1,36.5237

Just_Right_Fruit_&_Nut,K,C,140,3,1,170,2,20,9,95,100,3,1.3,0.75,36.4715

Kix,G,C,110,2,1,260,0,21,3,40,25,2,1,1.5,39.2411

Life,Q,C,100,4,2,150,2,12,6,95,25,2,1,0.67,45.3281

Lucky_Charms,G,C,110,2,1,180,0,12,12,55,25,2,1,1,26.7345

Maypo,A,H,100,4,1,0,0,16,3,95,25,2,1,1,54.8509

"Muesli_Raisins,_Dates,_&_Almonds",R,C,150,4,3,95,3,16,11,170,25,3,1,1,37.1369

"Muesli_Raisins,_Peaches,_&_Pecans",R,C,150,4,3,150,3,16,11,170,25,3,1,1,34.1398

Mueslix_Crispy_Blend,K,C,160,3,2,150,3,17,13,160,25,3,1.5,0.67,30.3134

Multi-Grain_Cheerios,G,C,100,2,1,220,2,15,6,90,25,1,1,1,40.106

Nut&Honey_Crunch,K,C,120,2,1,190,0,15,9,40,25,2,1,0.67,29.9243

Nutri-Grain_Almond-Raisin,K,C,140,3,2,220,3,21,7,130,25,3,1.33,0.67,40.6923

Nutri-grain_Wheat,K,C,90,3,0,170,3,18,2,90,25,3,1,1,59.6428

Oatmeal_Raisin_Crisp,G,C,130,3,2,170,1.5,13.5,10,120,25,3,1.25,0.5,30.4508

Post_Nat._Raisin_Bran,P,C,120,3,1,200,6,11,14,260,25,3,1.33,0.67,37.8406

Product_19,K,C,100,3,0,320,1,20,3,45,100,3,1,1,41.5035

Puffed_Rice,Q,C,50,1,0,0,0,13,0,15,0,3,0.5,1,60.7561

Puffed_Wheat,Q,C,50,2,0,0,1,10,0,50,0,3,0.5,1,63.0056

Quaker_Oat_Squares,Q,C,100,4,1,135,2,14,6,110,25,3,1,0.5,49.5119

Quaker_Oatmeal,Q,H,100,5,2,0,2.7,-1,-1,110,0,1,1,0.67,50.8284

Raisin_Bran,K,C,120,3,1,210,5,14,12,240,25,2,1.33,0.75,39.2592

Raisin_Nut_Bran,G,C,100,3,2,140,2.5,10.5,8,140,25,3,1,0.5,39.7034

Raisin_Squares,K,C,90,2,0,0,2,15,6,110,25,3,1,0.5,55.3331

Rice_Chex,R,C,110,1,0,240,0,23,2,30,25,1,1,1.13,41.9989

Rice_Krispies,K,C,110,2,0,290,0,22,3,35,25,1,1,1,40.5602

Shredded_Wheat,N,C,80,2,0,0,3,16,0,95,0,1,0.83,1,68.2359

Shredded_Wheat_'n'Bran,N,C,90,3,0,0,4,19,0,140,0,1,1,0.67,74.4729

Shredded_Wheat_spoon_size,N,C,90,3,0,0,3,20,0,120,0,1,1,0.67,72.8018

Smacks,K,C,110,2,1,70,1,9,15,40,25,2,1,0.75,31.2301

Special_K,K,C,110,6,0,230,1,16,3,55,25,1,1,1,53.1313

Strawberry_Fruit_Wheats,N,C,90,2,0,15,3,15,5,90,25,2,1,1,59.364

Total_Corn_Flakes,G,C,110,2,1,200,0,21,3,35,100,3,1,1,38.8397

Total_Raisin_Bran,G,C,140,3,1,190,4,15,14,230,100,3,1.5,1,28.5928

Total_Whole_Grain,G,C,100,3,1,200,3,16,3,110,100,3,1,1,46.6588

Triples,G,C,110,2,1,250,0,21,3,60,25,3,1,0.75,39.1062

Trix,G,C,110,1,1,140,0,13,12,25,25,2,1,1,27.7533

Wheat_Chex,R,C,100,3,1,230,3,17,3,115,25,1,1,0.67,49.7874

Wheaties,G,C,100,3,1,200,3,17,3,110,25,1,1,1,51.5922

Wheaties_Honey_Gold,G,C,110,2,1,200,1,16,8,60,25,1,1,0.75,36.1876