Data Analysis

Question 1

What is EDA?

Answer 1

Exploratory Data Analysis

Question 2

what is the process of eda

Answer 2

1. prep (collecting, cleaning)
2. explore (learn variables, compute summaries, find correlations/trends, visualize the data
3. hypothesis and further analysis

Question 3

what are summary statistics?

Answer 3

measures of central tendency: mean, median, avg

Question 4

Format Sum of Licenses Bought (in your pivot table) as a number with a , separator and 0 decimal places.

Answer 4

Right-click # - number format - number

Question 5

Create a Calculated Field that divides Sales Amount by Number of Users and call it “Sales per Sub”.

Answer 5

click in pivot - pivottable analyze - fields,items, and sets - calculated field

Question 6

which is switch and which is and IF statement?

B2>100,”you’re rich!”,”Keep saving.”)

B2,1,”One”,2,”Two”,3,”Three”

Answer 6

IF=B2>100,”you’re rich!”,”Keep saving.”)

SWITCH=B2,1,”One”,2,”Two”,3,”Three”

Question 7

how to find relationship between discounts and number of units sold

Answer 7

calculated field - =discounts/units sold

Question 8

explain SWITCH logic

Answer 8

=switch[@[from this column]],
(if)”Basic”,(then)10,
“Premium”,10,
“Business”,25,
“Enterprise”,27,
(if none of these, then) 0)

0 is a necessary default value

Question 9

IF formula for new column called “Non-Paying Users” that finds the difference on the row level between the Number of Users and Licenses Bought

Answer 9

=IF(#ofusers -licensesbought<0,0,#ofusers -licensesbought)

logic: if #users-licenses is less than 0, then 0, if not, then show the difference

Question 10

how do you re-include a moved column into the same nominal table as the rest of the sheet?

Answer 10

click in table - table design - resize table

Question 11

how do i Update a formula to only multiply if the Sales Month is the latest month, otherwise default to 0?

Answer 11

1. find latest Sales Month =MAX([Sales Month])
2. Modify the formula in your “Current Upsell $” column to only multiply when the Sales Month matches the latest month
   =IF([@[Sales Month]]=[@[Max Sales month]],[@[Non-paying users]]*[@[Upsell Per non-paying customer]],0)

Question 12

how do you Count the number of customers per month using Account Sales History, Customer ID, and Sales Month

Answer 12

=countif(whole sales month column, sales month specified on new sheet)

Question 13

how do you calculate the total number of sales for the month

Answer 13

=sumif(range:Sales month from account sales history og sheet, single cell sales month from sales trends sheet, sales amount from og sheet)

Question 14

how do you average the Total Sales per month by Number of Customers

Answer 14

=averageif(range:#of customers columnB:B, criteria:first cell #ofcust B:2,average_range: Total Sales column)

Question 15

how do you test your hypothesis that hat the share of non-paying customers (“Basic” subscriptions) are growing faster than our paying customers?

Answer 15

use COUNTIFS() to count the number of customers with a Basic subscription for the Sales Month.