Brainscape's Knowledge GenomeTM

Browse over 1 million classes created by top students, professors, publishers, and experts.


See full index

MGST 217 > Week 9 > Flashcards

Week 9 Flashcards

1
Q

How to make a pivot table?

A
  1. Select the data
  2. click on insert>inset pivot table
  3. go to existing worksheet and hit on the cell you want the data
  4. then basically you can drag and drop the fields onto the value, rows, columns
  5. REMEMBER value is where you can change field settings!!!!!! other than that play around till u get it
How well did you know this?
1
Not at all
2
3
4
5
Perfectly
2
Q

How to make a pivot chart

A
  1. select the data
  2. insert>pivot chart
  3. drag and drop fields into the dielf list
  4. rememebr that the values being counted go ointo the values ection!!!!
How well did you know this?
1
Not at all
2
3
4
5
Perfectly
3
Q

How to use scenario manager

A
  1. identify what are the changing cells going to be? THESE MUST BE LINKED TO A FORMULA !!!!
  2. WHAT-IF analysis >scenario maager
  3. name the scenario, and select the changing cells
  4. then put in the valeu you want (careful of decimals/or percentage)
  5. then add more scenarios and repeat

DO NOT CHANGE THE CHANIGNG CELLS!!!!!!!!

  1. then click summary > it will hcoose the cell linked formula
  2. then click ok and you will get scenario summary
How well did you know this?
1
Not at all
2
3
4
5
Perfectly
4
Q

How to do expected value?

A
  1. Probability values? just copy it down directly!!
  2. use scenario manager to calculate all the potential values
  3. input them into thecorrect space
  4. use sumproduct function to calculate it!!
How well did you know this?
1
Not at all
2
3
4
5
Perfectly
5
Q

What is regression

A

statistical method used to determine STRENGTH and character of the relationship between one dependant variable and independant variables

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
6
Q

Dependant vbl

A

Y

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
7
Q

Independant vbl

A

x

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
8
Q

what are potential regression values

A

FROM -1 TO 1

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
9
Q

If you have multiple x values, which r square values do you use?

A

ADJUSTED R SQUARE

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
10
Q

How to make scatter chart

A
  1. select chart insert the scatter chart
  2. select data
  3. add x axis data according to the given info
  4. add y axis data according to the given info
  5. select a series name by referencing a cell
How well did you know this?
1
Not at all
2
3
4
5
Perfectly
11
Q

Your confidence level is good if it is less than

what does this mean

A

0.05!!!!!!!!!

that you have at least 95% confidence

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
12
Q

What is R square?

A

Coefficient of determination!!!!

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
13
Q

How to use the intercept value and

A
How well did you know this?
1
Not at all
2
3
4
5
Perfectly
14
Q

How to do regression?

A

1.Select Data analysis
2. select regression adn okay buttion
3. now put the range from label:all values for X range
4. now put the range from label:all values for Y range
5. check on the labels box
6. create a new worksheet

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
15
Q

What should you read on the regression page?

A
  1. Rsquare (if single regression), Adjusted R square(multiple regression)
    2.P value (should be less that 0.05)
  2. coefficients= slope of each x; Intercept= y intercept

y=mx+b

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
16
Q

What does a high R square/adjusted r square value indicate?

A

That there is a great degree of determination!!!! That variable x explains A LOT of what happens in variable Y!!!

17
Q

How to do multiple regressionS?

A
  1. you have to change the x value!!! basically you need all the variables to be adjaecent to each other and then select a large range WITH THE LABELS!!!
18
Q

How to do expected value on regression

A
  1. copy and paste the values
  2. do the sumproduct function(first array: second array)+intercept
  3. first array should be the coefficients value, MAKE THESE ABSOLUTE!!!!!
  4. second array should be relative referencing the cells on top!
  5. copy and move it across!!
19
Q

HOW DO YOU KNOW IF ITS A GOOD REGRESSION

A
  1. Is the P value <0.05
  2. Is the R square value highest possible?
20
Q

Creating a histogram: by hand

A
  1. Create a bin of values (just a vertical column of values)
  2. data analysis>histogram
  3. Input range= this should be the entire column from data including the labels
  4. Bin Range= select the bin values!!
  5. you will get a new bin and frequency chart!! you can modify it if you would like
21
Q

Create a histogram via excel

A
  1. Create a bin of values
  2. Data analysis > histogram
  3. dont have the bin filled in leave it blank
  4. then excel automatically makes it for itself
22
Q

Google analytics

A

web analytics service offered by google that rarck and reports taffic

23
Q

Power BI

A

DATA VISUALIZATION software from microsogt

24
Q

For breakeven do what??

A

SET NET INCOME TO 0

MGST 217 (7 decks)

Brainscape helps you reach your goals faster, through stronger study habits.
© 2024 Bold Learning Solutions. Terms and Conditions