Situation:

The U.S. Bureau of Mines produces data on the price of Minerals. The data below displays the average prices per year for several minerals over a decade.

 

Gold ($ per oz.) Copper (cents per lb.) Silver ($ per oz.) Aluminum (cents per lb.)

161.1 64.2 4.4 39.8

308.0 93.3 11.1 61.0

613.0 101.3 20.6 71.6

460.0 84.2 10.5 76.0

376.0 72.8 8.0 76.0

424.0 76.5 11.4 77.8

361.0 66.8 8.1 81.0

318.0 67.0 6.1 81.0

368.0 66.1 5.5 81.0

448.0 82.5 7.0 72.3

438.0 120.5 6.5 110.1

382.6 130.9 5.5 87.8

 

Action:

Use the attached MS Excel spreadsheet data and multiple regression to produce a model to predict the average price of gold from other variables. Comment on the following:

1. Regression equation
2. R, R2 and 1-R2, adjusted R2
3. Standard error of estimate
4. Report the t's for each value and the corresponding p-values
5. Overall test of hypothesis and decision
6. Use a .05 level of significance. Cite which variables are significant and which are not significant, based on the t values and p values for each independent variable.

 

The word document has the whole question with the numbers in a readable table to make it easier. The excel document has the table and is the attached spreadsheet from the action step.

 

I'm looking for the data in a Microsoft Excel or Minitab format.

Thank you

• 1503076523-Question 5.docx

AccountingQueen

(3)

Status NEW Posted 18 Aug 2017 05:08 PM My Price 10.00

Hel-----------lo -----------Sir-----------/Ma-----------dam----------- T-----------han-----------k y-----------ou -----------for----------- us-----------ing----------- ou-----------r w-----------ebs-----------ite----------- an-----------d a-----------cqu-----------isi-----------tio-----------n o-----------f m-----------y p-----------ost-----------ed -----------sol-----------uti-----------on.----------- Pl-----------eas-----------e p-----------ing----------- me----------- on----------- ch-----------at -----------I a-----------m o-----------nli-----------ne -----------or -----------inb-----------ox -----------me -----------a m-----------ess-----------age----------- I -----------wil-----------l

Not Rated(0)

• Buy Answer