Author: Anonymous

What is the interquartile range (IQR) for Sales Price in the chart shown below?

The mean IQ is 100 with a standard deviation of 15. What is the z-score for a person with an IQ of 145?

A new business, CoolIT, sells items to keep you cool when outside. Its products include coolers, generators, floats, and other water accessories designed to beat the heat. CoolIT has been spending money on innovative advertising in hopes of increasing its sales revenue. A CoolIT business analyst ran a regression using 36 months of data using the Excel Data Analysis Toolpak. The output is shown below. Using the regression output, what is projected sales revenue if CoolIT spends $10,000 on advertising? SUMMARY OUTPUT Regression Statistics Multiple R 0.95011488 R Square 0.90271829 Adjusted R Square 0.89985706 Standard Error 6748.44918 Observations 36 ANOVA df SS MS F Significance F Regression 1 14368384267 1.44E+10 315.5004 8.92218E-19 Residual 34 1548413256 45541566 Total 35 15916797524 Coefficients Standard Error t Stat P-value Lower 95% Upper 95% Intercept −836512.83 54148.06535 −15.4486 6.16E-17 −946554.9386 −726470.7216 Advertising Exp 163.271654 9.192016768 17.76233 8.92E-19 144.5912287 181.9520799

Which of the following describes a column in a relational table/database that serves as a unique identifier?

What is the term for data about the data?

According to the normal distribution:

There are two primary methods to summarize nominal data; one is counting and grouping. What is the second method?

The appropriate test to compare one sample to another sample to see if one is greater than another in some way is called:

What term refers to all the items, events and interactions that determine a company’s financial health?

A new business, CoolIT, sells items to keep you cool when outside. Its products include coolers, generators, floats, and other water accessories designed to beat the heat. It opened the store at the beginning of June. Management has asked the following question: Is the average sale during the first 100 days of business different than the average sale during the second 100 days of business? A business analyst used the Excel Data Analysis ToolPak to create the following hypothesis test. Should the business analyst conduct a one-tailed or two-tailed hypothesis test to evaluate management’s question? t-Test: Two-Sample Assuming Unequal Variances First 100 Sales Second 100 Sales Mean 624.0999 584.6295 Variance 565742.2231 667136.4119 Observations 100 100 Hypothesized Mean Difference 0 df 197 t Stat 0.355476884 P(T