IDGET COMPANY
ANNING MODEL
1
Starting with last year (2011) as a base, Ram Widget wants to create a 4-year planning model.
2
Ram has the following expenses:
Cost of Goods Sold
Marketing
General Administration
3
Sales Revenue for 2011 was $360,000 and Cost

1. A) Null Hypothesis: = .06, 6% of vacation home owners are minorities
Alternate Hypothesis: .06, the percentage of minority home owners is greater than
6%
b) I chose a z test for the proportion since the example deals with a proportion of a
sample.
c) T

SUMMARY OUTPUT
Regression Statistics
Multiple R 0.9900204
R Square 0.9801404
Adjusted R Square
0.977658
Standard Error
0.2199554
Observations
10
R e s id ua ls
Rate% Residual Plot
ANOVA
df
Regression
Residual
Total
SS
MS
F
Significance F
1 19.101957 19.10

3a) Null Hypothesis: 5, the mean amount of weight loss is no less than 5 lbs.
Alternate Hypothesis: < 5, the mean amount of weight loss is less than 5 lbs.
b) I used a t-test for finding the value of a population mean since the population standard
deviati

The Write Stuff, Inc.
Monthly Sales and Analysis Report
August, 2013
2/14/2014
Raisa Ahmed Section RTF
Comission Rate
Target Percentage
5%
10%
Product
Pens
Pencils
Letterhead
Note Pads
Envelopes
Total
July 2013 Sales
August 2013 Target
August 2013 Sales %

Database Management Systems (DBMS): Software that enables
you to create, store, organize and retrieve data from one or many
databases ( both an application and and systems software)
Database Structure = Design View ; Database Contents =
Datasheet View
Dat