HBX Accounting/Economics/Analytics Questions and Answers (100% Correct Answers) Already Graded A+

Quantitative [ Ans: ] Can be measured in numbers Qualitative [ Ans: ] Need dummy to make it measurable in numbers Finding a Percent [ Ans: ] =percentile(array,k) Square Root [ Ans: ] =SQRT(#) Norm Distribution [ Ans: ] =(x,mean,standard_deviation,cumulative =(z,cumulative) Sum [ Ans: ] =sum(A2:A11) To Find Random Data [ Ans: ] =Rand() X Is The [ Ans: ] Independent Variable Y Is The [ Ans: ] Dependent Variable Revenue [ Ans: ] Annual income from which public expenses are met Conditional Average (Mean) [ Ans: ] =AverageIf(range,criteria,[average_range] Minimum Range [ Ans: ] =min(A2:A11) Creating Regression Models [ Ans: ] =IF(logical_test,[value_if_true],[value_if_false] Count [ Ans: ] =count(A2:A11) Mean [ Ans: ] =Average(#1,#2,#3) Median [ Ans: ] =median(#1,#2,#3) Mode [ Ans: ] =(#1,#2,#3) Range [ Ans: ] A group of cells in a spreadsheet Heteroskedasticity [ Ans: ] When two variables are considered unequal Return on Equity [ Ans: ] Net Income/Owners Equity Debt to Equity [ Ans: ] Average Total Liabilities/Average Total Equity Current Ratio [ Ans: ] Current Assets/Current Liabilities Cash Conversion Cycle [ Ans: ] Days Inventory+Average collection period-Days purchases outstanding Days Inventory [ Ans: ] 1. Average Inventory/COGS/365 2. 365/Inventory Turnover Interest Coverage Ratio [ Ans: ] EBIT/Interest Expense Times Interest Earned [ Ans: ] EBIT/Interest Expense Current Ratio [ Ans: ] Current Assets/Current Liabilities Days Purchases Outstanding [ Ans: ] 1. Average Accounts Payable/Annual credit purchases/365 2. Average Accounts Payable/COGS/365 3. 365/Accounts Payable Turnover Accounts Receivable Turnover [ Ans: ] Credit Sales/Average Accounts Receivable Accounts Payable Turnover [ Ans: ] 1. Credit Purchases/Average Accounts Payable 2. COGS/Average Accounts Payable Gross Profit Margin [ Ans: ] Gross Profit/Sales Quick Ratio [ Ans: ] Current Assets-Inventory/Current Liabilities Inventory Turnover [ Ans: ] COGS/Average Inventory Debt to Equity [ Ans: ] Average Total Liabilities/Average Total Equity Profit Margin [ Ans: ] Net Income/Sales Leverage [ Ans: ] Average Total Assets/Average Total Equity Expected Daily Revenue [ Ans: ] Revenue/Number of Goods Sold Single Regressio