Week 3 - More Excel Topics & Google Analytics

Question 1

What is a Sensitivity analysis and why would we use it?

Answer 1

Determine how answers change based on variables.

One-Way Sensitivity Analysis
Change one variable to see how it affects results.
Excel can look at a range of values.

Question 2

What is Conditional formatting and when would we use it?

Answer 2

• formatting change depending on the value of the cell or the value of a formula

Question 3

What are the various Dashboards in Excel?

Answer 3

aslkdj

Question 4

What are the various types things measured in Google analytics

Answer 4

- Acquisition 
How to drive traffic to site 
- Behavior 
How engaged users are 
- Visitor flow 
How users navigate site