SMB.cover.3.14.1.13.07

SMB.cover.3.14.1.13.07 - Cover Sheet for 3.14-monthly sales...

Info iconThis preview shows pages 1–2. Sign up to view the full content.

View Full Document Right Arrow Icon
Cover Sheet for “3.14-monthly sales” Computer Homework (1/13/07) Name____________________ Do the following EXCEL exercise including the two “Student Exercises” on the second page (you should separately replicate the overlay plot): The following seven data points consist of (Time on the job (in months), Monthly sales in $1,000): (2,2.4),(4,7),(8,11.3),(12,15),(1,0.8),(5,3.7),(9,12). Using EXCEL, get descriptive statistics for both variables, get a scatterplot of the data, get a histogram of each variable, and run a least squares regression analysis for predicting monthly sales (y) from months on the job(x). Select Data Analysis and then use descriptive statistics, histogram, and regression . If you don’t find Data Analysis under Tools , select ADD-INS and then the Analysis ToolPac. Cover sheet enclosed with more tips and required things to do. Make sure all graphs and histograms are correctly labeled. Use this cover sheet as the first page and check that all required items are included. Please don’t even think about checking an item on the check list if it has not been done correctly. Table of Contents: Check list check that item was done correctly and only then check off (____) Read p. 9 and both sides of this cover sheet _____ p. 1 -Print data (Data checked that it was accurately input ____) p. 1 -Descriptive Statistics (Variable names and separately units included _____) p.1 -Histograms (Two-1 for each var.-no freq. table, “bin” replaced with var. name, units listed ____) p.1 -Scatterplot (y-variable on y axis if included, variable name and separately units included____) Wrote coordinate by hand of one checked point plotted correctly nearby each plot and circled checked point on plot____. (Handdrawn “y-bar” line and model thru estimate of “E(y|x)” in each plot (y=variable on y axis)_____, including all residual plots below_____) p.2 -Regression (x variable (not y variable) is listed under Intercept ____) p.2 -Histogram of Residuals (no freq. table, “bin” replaced with variable name and units listed ____)
Background image of page 1

Info iconThis preview has intentionally blurred sections. Sign up to view the full version.

View Full DocumentRight Arrow Icon
Image of page 2
This is the end of the preview. Sign up to access the rest of the document.

Page1 / 2

SMB.cover.3.14.1.13.07 - Cover Sheet for 3.14-monthly sales...

This preview shows document pages 1 - 2. Sign up to view the full document.

View Full Document Right Arrow Icon
Ask a homework question - tutors are online