MKTG Assignment 1

docx

School

University Of Arizona *

*We aren’t endorsed by this school

Course

376

Subject

Marketing

Date

Feb 20, 2024

Type

docx

Pages

Uploaded by ChancellorLeopardMaster486

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 - Ordinal b. Number of text messages sent - Discrete c. Level of agreement (example: strongly agree, somewhat agree, etc.) - Nominal d. Body Temperature in Fahrenheit – 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.09 Median 9 Standard Deviation 0.57 Sample Variance 0.33 Count 135 Skewness -0.03 b. Create a histogram for the price of 3M tape in a column chart. Is it symmetric or skewed? (2 points) The column chart is skewed. 8 8.2 8.4 8.6 8.8 9 9.2 9.4 9.6 9.8 10 0 5 10 15 20 25 30 Price Column Chart Total 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) There is a downward trend in sales. Copy and paste the pivot tables and charts here Row Labels Sum of Units Sold 2009 88874.96554 2010 69508.22495 2011 42212.27134 Grand Total 200595.4618 2009 2010 2011 0 10000 20000 30000 40000 50000 60000 70000 80000 90000 100000 Sales Trends Total 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 RowLabels Sum of Units Sold Jan 4.40% Feb 7.97% Mar 9.38% Apr 9.91% May 13.18% Jun 11.24% Jul 10.16% Aug 13.38% Sep 5.74% Oct 7.90% Nov 4.24% Dec 2.51% Grand Total 100.00%

Jan Feb Mar Apr May Jun Jul Aug Sep Oct Nov Dec 0.00% 2.00% 4.00% 6.00% 8.00% 10.00% 12.00% 14.00% 16.00% Sales Trends Total c. Does an ad campaign appear to increase unit sales on average? (Hint: Just compare average unit sales) (2 points) Yes ad campaigns appear to increase unit sales on average. Copy and paste the pivot tables here RowLabels Average of Units Sold 0 1195.179711 1 2461.186188 Grand Total 1485.89231 Excel Charts (6 points) 3. You can download the data ExcelChart.xlsx from D2L. All charts should have titles, legends, and proper axes titles by default. a. Worksheet a includes monthly average temperatures and rainfall in Bloomington, Indiana. Create a combination chart involving a column and line graph with a secondary axis to chart the temperature and rainfall data. (3 points) Copy and paste the chart here Janu ary February Mar ch April May June Jul y Augus t September October November Decemb er 0 0.1 0.2 0.3 0.4 0.5 0.6 0.7 0.8 0.9 0 20 40 60 80 100 Rainfall Combination Chart Rainfall Temperature Moving average (Temperature) Rainfall Temperature

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

b. The worksheet b contains monthly tomato sales on Farmer Smith’s farm. Summarize this data using a chart with pictures of tomatoes, data labels, and a data table. (3 points) Copy and paste the chart here Row Labels Sum of Sales January 400 February 600 March 700 April 900 May 1100 June 1300 Grand Total 5000 4. Hypothesis Testing You can download the data CoffeeData4Testing.xlsx from D2L Use the Pivot Table tool to compute the input for the test statistics. Use Excel functions to compute the values of the test statistics. Assume for all hypothesis tests that have a level of significance α=.05. Data Description: CoffeeData4Testing.xlsx contains data from a survey about coffee consumption. The variables are: ID A unique identifier for each respondent in the survey. Gender 1=Men 2=Women Age Age of the respondent Spending Money spent on coffee a day Type Preferred Type of Coffee: Hot, Cold or Frozen Make/Buy Whether the primary method of acquiring coffee is to make or buy Exercise 1. Test One Mean (7 points) a.A coffee shop owner wanted to determine if the average spending on coffee per day for men was greater than 3 dollars. Write the null and alternative hypotheses for this question Null: Men spend less than $3 on coffee per day. Alternative: Men spend an average of $3 or more on coffee per day.

b. Compute z-statistic 6.56 − 3 √ 13.32 2 / 41 = 3.56 2.08 = 1.71 For the mean and variance, create a pivot table and: 1. Put GENDER in ‘ROW’. 2. Put Spending in ‘VALUES’. 3. Remember to change the Field in the top left corner from SUM to the AVERAGE for the mean, VAR for the variance, Count for the sample size. ¯ x men = average spending for men = $6.56 = variance of spending for men = 13.32 n men = number of men = 41 c.Test Statistics 1-tail or 2-tail: 1-tail Critical Value: *hint: use excel function =NORM.S.INV(0.95): 1.64485 d. Should you fail to reject H0 or reject H0 and why? State your conclusion. We can reject the null hypothesis, because our z-statistic is within the rejection region. Therefore, we can prove that men do spend an average of $3 or more on coffee per day.

Related Documents

wk 5UMGC MRKT Marketing Plan Part 41.docx

wk 4 UMGC MRKT Marketing Plan Part 31.docx

Reflection 2 Rounds 4-9.docx

Trends Analysis-John Heacock.docx

Gillespie Tesla Case Study.pptx

Natureview Farm.docx

discussion2.docx

Buisness.docx

5-2 Final Project Milestone Two_ Social Media Marketing Analytics.docx

StevensC_MKT 461_Netflix Case Analysis.docx

StevensC_MKT 461_Decathlon Case Analysis.docx

Formal_Outline_174053.pdf

Recommended textbooks for you

Principles Of Marketing

Marketing

ISBN:9780134492513

Author:Kotler, Philip, Armstrong, Gary (gary M.)

Publisher:Pearson Higher Education,

Marketing

ISBN:9781259924040

Author:Roger A. Kerin, Steven W. Hartley

Publisher:McGraw-Hill Education

Foundations of Business (MindTap Course List)

Marketing

ISBN:9781337386920

Author:William M. Pride, Robert J. Hughes, Jack R. Kapoor

Publisher:Cengage Learning

Marketing: An Introduction (13th Edition)

Marketing

ISBN:9780134149530

Author:Gary Armstrong, Philip Kotler

Publisher:PEARSON

MKTG 12:STUDENT ED.-TEXT

Marketing

ISBN:9781337407595

Author:Lamb

Publisher:Cengage

Contemporary Marketing

Marketing

ISBN:9780357033777

Author:Louis E. Boone, David L. Kurtz

Publisher:Cengage Learning

SEE MORE TEXTBOOKS

Recommended textbooks for you

Principles Of Marketing
Marketing
ISBN:9780134492513
Author:Kotler, Philip, Armstrong, Gary (gary M.)
Publisher:Pearson Higher Education,
Marketing
Marketing
ISBN:9781259924040
Author:Roger A. Kerin, Steven W. Hartley
Publisher:McGraw-Hill Education
Foundations of Business (MindTap Course List)
Marketing
ISBN:9781337386920
Author:William M. Pride, Robert J. Hughes, Jack R. Kapoor
Publisher:Cengage Learning
Marketing: An Introduction (13th Edition)
Marketing
ISBN:9780134149530
Author:Gary Armstrong, Philip Kotler
Publisher:PEARSON
MKTG 12:STUDENT ED.-TEXT
Marketing
ISBN:9781337407595
Author:Lamb
Publisher:Cengage
Contemporary Marketing
Marketing
ISBN:9780357033777
Author:Louis E. Boone, David L. Kurtz
Publisher:Cengage Learning