Excel/Regression question

Drink mix

sales	ownprice	compprice	disp	dispad
6439	0.66	0.82	1	0
3329	0.62	0.8	1	0					variable	description
3415	0.62	0.77	0	0					sales	sales in units
2909	0.62	0.66	0	0					ownprice	price, in US $'s
2598	0.63	0.65	0	0					compprice	price, in US $'s
3773	0.69	0.63	0	0					disp	product featured on display
20383	0.63	0.65	0	1					dispad	product featured on display and in weekly ad
11761	0.65	0.78	1	0
2614	0.77	0.62	1	0
2496	0.81	0.69	1	0
20811	0.68	0.85	0	1
8339	0.71	0.86	1	0
2793	0.84	0.86	1	0
2416	0.82	0.86	0	0
2837	0.84	0.86	0	0
2110	0.82	0.77	0	0
6422	0.78	0.82	1	0
4539	0.81	0.91	1	0
2493	0.89	0.91	0	0
2262	0.85	0.89	0	0
2145	0.85	0.89	0	0
11996	0.71	0.9	0	1
5847	0.78	0.92	1	0
2257	0.85	0.43	1	0
2461	0.87	0.82	0	0
2075	0.86	0.93	1	0
14044	0.77	0.9	0	1
4521	0.8	0.75	0	0
2052	0.85	0.76	0	0
1762	0.85	0.89	0	0
2375	0.87	0.91	0	0
3256	0.88	0.85	0	0
3280	0.83	0.78	0	0
27254	0.69	0.93	0	1
14129	0.69	0.92	1	0
2906	0.9	0.91	1	0
17630	0.69	0.68	0	1
9431	0.73	0.69	1	0
32820	0.61	0.73	0	1
12635	0.67	0.9	1	0
2509	0.89	0.91	1	0
2184	0.89	0.59	1	0
12485	0.7	0.65	0	1
6560	0.75	0.9	1	0
2647	0.92	0.91	1	0
2949	0.91	0.92	1	0
3016	0.91	0.91	1	0
2370	0.91	0.91	0	0
2006	0.91	0.76	0	0
2556	0.9	0.77	0	0
13808	0.69	0.76	0	1
6668	0.82	0.77	1	0

Example tables

ECON 301 Managerial Economics Exam 1
Example Summary Statistics
Variable	Description	Mean	Std Dev	Min	Max
Motel Occupancy Rate	% monthly rate	0.56	0.02	0.53	0.60
Room price	in US $'s	76.00	4.65	67.45	83.90
Competitor price	in US $'s	75.64	14.44	39.20	83.90
Income	in 000s of US $'s	62.74	11.10	42.90	83.90
District	% of sample
Sherman Hill		10%
Downtown		80%
East Village		10%
Notes: Sample size is 534 for all variables.
ECON 301 Managerial Economics Exam 1
Example Linear Regression Results
Dependent Variable: Motel Occupancy Rate (%)
	Coefficient	Standard Error	t stat	p-value
Intercept	50.174	7.847	6.394	0.000
Room price	0.144	0.117	1.235	0.230
Competitor price	-0.083	0.041	-2.007	0.058
Income	0.026	0.064	0.404	0.690
Notes: Sample size is 534.