Week 9 Flashcards
How to make a pivot table?
- Select the data
- click on insert>inset pivot table
- go to existing worksheet and hit on the cell you want the data
- then basically you can drag and drop the fields onto the value, rows, columns
- REMEMBER value is where you can change field settings!!!!!! other than that play around till u get it
How to make a pivot chart
- select the data
- insert>pivot chart
- drag and drop fields into the dielf list
- rememebr that the values being counted go ointo the values ection!!!!
How to use scenario manager
- identify what are the changing cells going to be? THESE MUST BE LINKED TO A FORMULA !!!!
- WHAT-IF analysis >scenario maager
- name the scenario, and select the changing cells
- then put in the valeu you want (careful of decimals/or percentage)
- then add more scenarios and repeat
DO NOT CHANGE THE CHANIGNG CELLS!!!!!!!!
- then click summary > it will hcoose the cell linked formula
- then click ok and you will get scenario summary
How to do expected value?
- Probability values? just copy it down directly!!
- use scenario manager to calculate all the potential values
- input them into thecorrect space
- use sumproduct function to calculate it!!
What is regression
statistical method used to determine STRENGTH and character of the relationship between one dependant variable and independant variables
Dependant vbl
Y
Independant vbl
x
what are potential regression values
FROM -1 TO 1
If you have multiple x values, which r square values do you use?
ADJUSTED R SQUARE
How to make scatter chart
- select chart insert the scatter chart
- select data
- add x axis data according to the given info
- add y axis data according to the given info
- select a series name by referencing a cell
Your confidence level is good if it is less than
what does this mean
0.05!!!!!!!!!
that you have at least 95% confidence
What is R square?
Coefficient of determination!!!!
How to use the intercept value and
How to do regression?
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
What should you read on the regression page?
- Rsquare (if single regression), Adjusted R square(multiple regression)
2.P value (should be less that 0.05) - coefficients= slope of each x; Intercept= y intercept
y=mx+b
What does a high R square/adjusted r square value indicate?
That there is a great degree of determination!!!! That variable x explains A LOT of what happens in variable Y!!!
How to do multiple regressionS?
- 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!!!
How to do expected value on regression
- copy and paste the values
- do the sumproduct function(first array: second array)+intercept
- first array should be the coefficients value, MAKE THESE ABSOLUTE!!!!!
- second array should be relative referencing the cells on top!
- copy and move it across!!
HOW DO YOU KNOW IF ITS A GOOD REGRESSION
- Is the P value <0.05
- Is the R square value highest possible?
Creating a histogram: by hand
- Create a bin of values (just a vertical column of values)
- data analysis>histogram
- Input range= this should be the entire column from data including the labels
- Bin Range= select the bin values!!
- you will get a new bin and frequency chart!! you can modify it if you would like
Create a histogram via excel
- Create a bin of values
- Data analysis > histogram
- dont have the bin filled in leave it blank
- then excel automatically makes it for itself
Google analytics
web analytics service offered by google that rarck and reports taffic
Power BI
DATA VISUALIZATION software from microsogt
For breakeven do what??
SET NET INCOME TO 0