Comm 291 Statistics Populations Parameters 2014 Assignment 2 Berkowitz

Mean sd min q1 median q3 max customs total bop total

Info iconThis preview shows page 1. Sign up to view the full content.

View Full Document Right Arrow Icon
This is the end of the preview. Sign up to access the rest of the document.

Unformatted text preview: ables, “Customs” Total and “Payments” Total. Then construct two histograms of these two new variables. You may choose whatever bin width you want, but I recommend bin widths of 2,000, beginning with 14,000. Remember to label your charts clearly (title, x-axis, yaxis). Comment on the distributions. Customs Total 40 35 30 25 20 15 10 5 0 Frequency Frequency Revenue ($0,000) Balance of Payments Total 45 40 35 30 25 20 15 10 5 0 Revenue ($0,000) The distributions are both positively skewed, indicating a growth in Canadian international trade. The BOP is higher by 2000, indicating that it is a wider measure of trade in Canada. 7 e) For the two new variables in part d), compute the numerical summaries for each distribution (mean, SD, median, and the five-number summary) and present in a table. Use the following format. Report each value to the nearest whole number. Mean SD Min Q1 Median Q3 Max Customs Total BOP Total 20062 3653 14790 17538 18928 21438 34617 21821 3647 16484 19443 20736 23104 36138 8 Question 3 – TV Advertising and Revenues You are the company’s marketing analyst. You have discovered through an analysis of last year’s revenues that sales have significantly benefited from the use of television ads. You need to present this benefit to the CEO. The data are provided below and also provided in the <TVAds> spreadsheet. TV Spots Revenue Jan 20 $50K Feb 25 $55K Mar 20 $52K Apr 30 $57K May 30 $58K Jun 30 $59K Jul 30 $57K Aug 20 $50K Sep 15 $45K Oct 25 $55K Nov 30 $63K a) Construct two time series plots on the same axes. 90 80 70 60 50 TV Ads 40 Revenue ($000s) 30 20 10 0 Jan Feb Mar Apr May Jun Jul Aug Sep Oct Nov Dec b) Construct scatterplot of TV Spots (X) vs. Revenue (Y). Make the X-axis range from 10 to 40 and the y-axis range from 40 to 80. Be sure to label your axes. TV Spots (X) vs. Revenue (Y) 80 75 Revenue 70 65 60 55 Revenue ($000s) 50 45 40 10 15 20 25 30 35 40 TV Spots Per Month 9 Dec 35 $78K c) Describe the look of the scatterplot (i.e. shape, direction, strength, outliers) in at most two sentences. The Scatter Plot shows a fairly linear positive upwards trend up. The trench is strong with one outlier at (35,78). d) What does the scatterplot show you th...
View Full Document

Ask a homework question - tutors are online