Question: Using the ADVERTISING variable and the descriptive statistics you have learned in class,tell me a little about this variable (*** starred items indicate questions you should discuss in your Word file).

1. Using the Excel Descriptive Statistics Data Analysis tool, create a complete descriptive statistics table including the mean, median, mode, sample size, and standard deviation for your ADVERTISING variable.
2. Use the Excel function tool (fx) to determine the median, standard deviation, and 65 ^th percentile for your ADVERTISING variable.
3. *** Is the sample skewed based on the ADVERTISING variable (tell me based on the mean/median values as well as the skewness value)? If it is skewed, is it positively or negatively skewed? What does this tell us about the shape of our sample based on the ADVERTISING variable? Tell me about what this means in your own words.
4. Determine a LOGICAL grouping schema for the clinics based on the ADVERTISING variable. Next, use Excel’s "Histogram" function to divide the clinicsinto several groups based on the ADVERTISING variable and create a frequency table for this variable based on the groups you have created. NOTE: I’ve already started the table for you in the Excel file.
5. Use the absolute cell function and create a relative frequency for ADVERTISING in your frequency table. Re-format this value as a percentage.
6. Construct a bar chart from your relative frequency distribution (number in each group). Label your chart appropriately, includingtitles and data labels for each group.
7. *** Describe your sample in detail (at least 3 – 4 sentences) using all of the descriptive statistics listed above, as well as the range, the frequency table, bar chart, percentages, standard deviation, fractile, etc.

Price: $2.99

Solution: The downloadable solution consists of 2 pages
Deliverable: Word Document