1How is standard deviation used as a business analytic?2Describe the purposes of the Excel's standard deviation functions.3Define "confidence interval" and how it relates to business anqalytics.4Compute the 95% confidence interval for the following data. See instructions in the comment field.Passersby544468Upper bound399Lower bound759526CONFIDENCE.T212Upper bound256Lower bound4565532594693661971785The following are data showing the advertising budget and unit sales for a company. Unit Sales$3,500 16,523$10,073 6,305$11,825 1,769$33,550 30,570$37,200 7,698$55,400 9,554$55,565 54,154$66,501 54,450$71,000 47,800$82,107 74,598$83,100 25,257$90,496 80,608$100,000 40,800$102,100 63,200$132,222 69,675Create an X-Y Scatter Diagram (Scatterplot) for the data. Insert a trend line. Also include the regression equation and the R2 on the chart.Advertising Budget
$136,297 98,715$139,114 75,886$165,575 83,3606Given the strong linear relationship between the advertising budget and uni sales in the previous example, can it be said that the budgeted dollars caused the sales?A for Yes; B for No.7Use Excel's regression tool to perfrom a regression analysis for the budged and sales data in the above dataset. Treat the advertising budget as the independent variaPlace the results In B97.8Using the TREND function as an ARRAY function, for the data in the above item predict the unit sales for the following advertising budget dollar amounts.$200,000$210,0009Use LINEST to perform a regression analysis on the budget and unit data above. Treat unit sales as the dependent variable.10The following adds additional data (Sales Price) to the dataset the previous problems used.Treating Advertising Budget and Sales Price, use the Regression tool in Data Analysisto conduct a regression analysis with Unit Sales as the dependent variable.Specify F137 as the Output Range.Sales PriceUnit Sales$3,500 $88 16,523$10,073 $110 6,305$11,825
You've reached the end of your free preview.
Want to read all 43 pages?
- Fall '15