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

Uploaded by s22600789

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

Row Labels Average of Units Sold Jan 65.95% Feb 89.64% Mar 90.44% Apr 111.46% May 127.10% Jun 116.72% Jul 114.32% Aug 120.45% Sep 96.84% Oct 133.23% Nov 57.24% Dec 42.36% Grand Total 100.00% c. Does an ad campaign appear to increase unit sales on average? (Hint: Just compare average unit sales) (2 points) Copy and paste the pivot tables here Ads Average of Units Sold 0 1195.179711 1 2461.186188 Grand Total 1485.89231 There does appear to be an increase in average units sold when the ad campaign increases.

3. Excel Charts (6 points) 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) 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)

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 H 0 : µ≤$ 3 H A : µ > $ 3 b. Compute z-statistic = 3.9 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.5583 = variance of spending for men = 13.3230 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.6449

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

d. Should you fail to reject H0 or reject H0 and why? State your conclusion. Reject null hypothesis ( H 0 ) Because there is sufficient evidence to suggest that the average spending on coffee per day for men was greater than 3 dollars.

Related Documents

Discussion Chapter 3.docx

_Week 5 Case Discussion Reflection.docx

Marketing Module 8 Assignment.docx

Task 5 - Role Play Template.docx

Chapter 5 Case Study_Final.docx

Brand Analysis.docx

RACI Matrix.xlsx

Case Analysis.pdf

MKTG742_ Assignment 1_ JKhurana_301367976.docx

Minicase 1.docx

Strategic case 02.docx

MKTG 41003D Marketing Plan Overview W2023.docx

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