Assignment 1- Jocelyn Schmitt

.docx

School

University Of Arizona *

*We aren’t endorsed by this school

Course

376

Subject

Marketing

Date

Feb 20, 2024

Type

docx

Pages

7

Uploaded by s22600789

Report
MKTG 376 Assignment 1: Data, Excel, and Hypothesis Testing Due: February 5, 11:59pm 1. Data For each of the variables below, describe their type (categorical – ordinal or nominal; numerical – discrete/continuous):(2 points) a. College year = Categorical, ordinal b. Number of text messages sent = numerical, discrete c. Level of agreement (example: strongly agree, somewhat agree, etc.) = categorical, ordinal d. Body Temperature in Fahrenheit = numerical, continuous 2. The tapedata.xlsx (posted on D2L) contains data for weeks during 2009-2011 for the unit sales of 3M tape, price charged, whether an ad campaign was run that week (1=ad campaign), and whether the product was displayed on the end of the aisle (1=end cap). Use this file to perform the following exercises: Exercise 1. Descriptive Statistics (4 points) a. Calculate the following statistics for the price of 3M tape: mean, median, standard deviation, sample variance, count, and skewness. (Hint: Use Analysis Toolpak Data Data Analysis Descriptive Statistics) (2 points) Descriptive Statistics Mean  9.085926 Median 9 Standard Deviation  0.571698 Sample Variance  0.326839 Count  135 Skewness -0.02678 b. Create a histogram for the price of 3M tape in a column chart. Is it symmetric or skewed? (2 points) Symmetric
Exercise 2. Excel PivotTables (6 points) a. Does there appear to be an upward trend in sales? (Hint: summarize average unit sales by year) (2 points) Row Labels Average of Units Sold 2009 1851.561782 2010 1336.696634 2011 1206.064895 Grand Total 1485.89231 There was not an upward trend in sales. As the years went on, there was a decrease in average of units sold. b. Analyze the nature of the monthly seasonality of tape sales in a line graph (Hint: summarize average unit sales by month and show it as percentage) (2 points) Copy and paste the pivot tables and charts here
Your preview ends here
Eager to read complete document? Join bartleby learn and gain access to the full version
  • Access to all documents
  • Unlimited textbook solutions
  • 24/7 expert homework help