How do I make a pivot table?

[neovan]

with this data set

thanks for the homework help! 😀

if you can help me further with my homework, here's the rest of it. 😛

 

[neovan]

help please 🙁

 

[CaseTragedy]

select your columns
data > pivot tables
add industry to row/column area
add rest to data area
change field settings for data area to averages


-Case

 

[neovan]

thanks Case

now what the hell does he mean by "prepare the data to run the following model:
SHIP=B+B1EMPLOY + B2OVERTIME + B3IRON + B4RUBBER + B5STONE + e

(he didn't explain it very well in class). Thanks!

 

[ggavinmoss]

What exactly is a Pivot Table? I've always seen the feature in Excel but never had any motivation to look it up in Excel Help.

-geoff

 

[HomeBrewerDude]

Originally posted by: ggavinmoss
What exactly is a Pivot Table? I've always seen the feature in Excel but never had any motivation to look it up in Excel Help.

-geoff

its an semi automated tool for aggregating and disagregating data quickly.

the term pivot is used to reflect the feature that you can 'pivot' variables from columns to rows by dragging and dropping them (and vice versa).

 

[neovan]

Originally posted by: ggavinmoss
What exactly is a Pivot Table? I've always seen the feature in Excel but never had any motivation to look it up in Excel Help.

-geoff

A pivot table is a great reporting tool that sorts and sums independent of the original data layout in the spreadsheet.

 

[ggavinmoss]

Originally posted by: HomeBrewerDude

Originally posted by: ggavinmoss
What exactly is a Pivot Table? I've always seen the feature in Excel but never had any motivation to look it up in Excel Help.

-geoff

its an semi automated tool for aggregating and disagregating data quickly.

the term pivot is used to reflect the feature that you can 'pivot' variables from columns to rows by dragging and dropping them (and vice versa).

Thanks!

-geoff

 

[neovan]

bump for more help 🙁

 

[CaseTragedy]

Originally posted by: neovan
thanks Case

now what the hell does he mean by "prepare the data to run the following model:
SHIP=B+B1EMPLOY + B2OVERTIME + B3IRON + B4RUBBER + B5STONE + e

(he didn't explain it very well in class). Thanks!

it means you'll be running a regression with excel.


-Case

 

[neovan]

i realize i'm going to be running a regression but when i choose it in the data analysis it asked me for which is x and y axis but i don't know where to begin after that. 🙁 🙁

 

[CaseTragedy]

Originally posted by: neovan
i realize i'm going to be running a regression but when i choose it in the data analysis it asked me for which is x and y axis but i don't know where to begin after that. 🙁 🙁

In order to get it ready, you'll have to change the industry column to categorical variables. So make 2 more columns--one for IRON and another for RUBBER--then put a '1' for anything thats rubber in the rubber column & '0' for anything thats not. Do the same for the iron column.

Your y input is the SHIP column--your x inputs are all the other columns (except INDUSTRY).


-Case

edit: Forgot--you need a column for STONE too.