Customer Sales Christmas State of Residence Holden 362 97 72 59 WA Cary 116 28 33 26 WA Lingg 292 28 58 46 WA Mundy 115 88 26 13 WA Flores 797 31 143 19 WA Rankin 996 78 188 84 WA Domingo 347 46 69 49 WA Price 188 79 37 76 ID Chow 179 88 35 98 ID Schieber 554 27 115 ID Hendrickson 820 28 385 ID Malone 537 38 107 48 ID Kagen 982 28 196 46 ID Lyman 337 65 69 95 ID Gross 504 87 94 97 OR Osborne 172 5 34 5 OR Stevens 361 5 72 3 OR Carruth 828 172 25 OR Field 359 37 71 87 OR Thiesen 332 66 4 OR McClaren 185 37 39 07 OR Knorr 237 32 47 46 MT Smith 169 32 33 86 MT Knoxx 353 93 72 79 MT Ellis 1,497 68 299 54 MT Buchannan 829 32 165 86 MT Pierce 188 37 36 5 MT Hayes 225 45 MT Garfield 169 49 33 9 NV Arthur 985 99 204 2 NV Cleveland 188 78 37 76 NV MCKinnley 582 81 116 56 NV Taft 228 55 13 NV Wison 342 75 68 55 NV Harding 988 83 194 77 NV Coolidge 398 82 79 76 UT Hoover 345 72 31 UT Roosevelt 387 77 4 UT Truman 192 9 39 4 UT Bilson 216 42 43 28 UT Michele 227 46 84 UT Field 176 33 35 27 UT The 2016 Sales data contains customers historical annual sales and their Christmas spend Build a model to estimate upcoming Christmas spend based on their annual sales Evaluate the goodness of fit try to improve the models fit to over 90

Question: Customer Sales Christmas State of Residence Holden 362.97 72.59 WA Cary 116.28 33.26 WA Lingg 292.28 58.46 WA Mundy 115.88 26.13 WA Flores 797.31 143.19

Customer	Sales	Christmas	State of Residence
Holden	362.97	72.59	WA
Cary	116.28	33.26	WA
Lingg	292.28	58.46	WA
Mundy	115.88	26.13	WA
Flores	797.31	143.19	WA
Rankin	996.78	188.84	WA
Domingo	347.46	69.49	WA
Price	188.79	37.76	ID
Chow	179.88	35.98	ID
Schieber	554.27	115	ID
Hendrickson	820.28	385	ID
Malone	537.38	107.48	ID
Kagen	982.28	196.46	ID
Lyman	337.65	69.95	ID
Gross	504.87	94.97	OR
Osborne	172.5	34.5	OR
Stevens	361.5	72.3	OR
Carruth	828	172.25	OR
Field	359.37	71.87	OR
Thiesen	332	66.4	OR
McClaren	185.37	39.07	OR
Knorr	237.32	47.46	MT
Smith	169.32	33.86	MT
Knoxx	353.93	72.79	MT
Ellis	1,497.68	299.54	MT
Buchannan	829.32	165.86	MT
Pierce	188.37	36.5	MT
Hayes	225	45	MT
Garfield	169.49	33.9	NV
Arthur	985.99	204.2	NV
Cleveland	188.78	37.76	NV
MCKinnley	582.81	116.56	NV
Taft	228	55.13	NV
Wison	342.75	68.55	NV
Harding	988.83	194.77	NV
Coolidge	398.82	79.76	UT
Hoover	345	72.31	UT
Roosevelt	387	77.4	UT
Truman	192.9	39.4	UT
Bilson	216.42	43.28	UT
Michele	227	46.84	UT
Field	176.33	35.27	UT

The 2016 Sales data contains customers’ historical annual sales and their Christmas spend.

Build a model to estimate upcoming Christmas spend based on their annual sales.

Evaluate the goodness of fit; try to improve the model’s fit to over 90%.

Step by Step Solution

★★★★★

3.46 Rating (153 Votes )

There are 3 Steps involved in it

1 Expert Approved Answer

Step: 1 Unlock

We will build a linear regression model to predict Christmas spend based on annual sales The model w... View full answer

Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock

Step: 3 Unlock

Students Have Also Explored These Related Accounting Questions!

Lezinah Ncube has just taken a new job as regional manager of a limited service hotel chain. Her region includes six hotels, with each hotel consisting of approximately 150 rooms each. Each hotel...

Hanson Company reported net income of $44,000 for 2015. The company has 10,000 shares of common stock and no preferred stock. During 2014 the company issued $400,000 of 8 percent convertible bonds at...

Your brother-in-law, Fred Miles, has just taken a new position as the plant manager of a local production facility. He has been told that the company uses a balanced scorecard approach to evaluate...

I would like all the questions answered as a study reference Quantitative Techniques for Business Project School of Economics and Finance Curtin University Felix Chan March 9, 2016 1 Introduction The...

Esther's Hypotheses 1. There are stark differences between male and female customers and operators. a. We have identified most of the difference between male and female operators (Thanks Juan)....

The company will be developing a payroll system using the SDLC. Currently, the project is in Phase 1 ("Definition"). Because it has yet to be determined if an Orange County location will be opened,...

I need help with this budget assignment, I have attached the instructions BUSI 523 BUDGET PROPOSAL INSTRUCTIONS Instructions: Complete each part of the following Case Study. You will need to use...

U.S. BUREAU OF LABOR STATISTICS D E C E M B E R 2 0 1 4 R E P O R T 1 0 5 1 Highlights of women's earnings in 2013 note that the comparisons of earnings in this report are on a broad level and do not...

Please help with this finance questions and see below necessary attached documents. Dashboards You are presented with a data file that includes sales to date by product, customer type etc. You have...

May Shipments Customer Zipcode 45140 40069 51108 53154 30106 30567 08054 35603 76011 41042 60915 92394 49548 53916 30336 28341 07728 L9P 1J5 54971 64755 43219 60164 92394 97230 72701 90220 76104...

During 20X1. Ramona Earthquake Prevention Products had sales of $4,200,000, of which 70% were on credit. The beginning balance in the Accounts Receivable lon January 1, 20X1) was $460,000. The...

Systems Analyst role is difficult and challenging. In addition, you likely have a greater appreciation for the significant contributions these professionals make to the results of the organization...

Points: 25 Graduation Party Stakeholder Management Plan Stakeholder Management Graduation Project 1. Identify & Analyze Stakeholders: Drawing on the charter you created, create a stakeholder register...

FNSACC412 Prepare Operational Budgets You are the bookkeeper for Brad's Vegan Ice Creamery. The business has had a bumper year in terms of sales volumes, but there are concerns about the fall in...

You have inherited the project management of a system implementation. The implementation of a group project has been broken down into the following activities, whose durations and dependencies are as...

A sample of a reinsurer's payments made under a proportional reinsurance arrangement consists of the following values, in units of thousands of pounds: 4.5, 6.8, 22.9, 1.4, 3.8, 10.2, 19.4, 32.1 If...

18 Malhotra Company pays annual dividends of $4.80 per share and is priced at $93.20 with a 15% market rate of return. What is the capital gains yield? 9.23% 10.00 % 7.35% 9.85 % 7.78% 0

7. Baladna wants to analyze process that includes delivery by suppliers, production inside the company, transportation to to its customers and information systems. Then it also wants to find out...

A hotel had a GOP of $125,000 this accounting period and a GOP of $100,000 the previous accounting period. Total revenue was $300,000 the previous period and $350,000 this period. What was this...

Which type of budget is always of a limited time duration; such as a day, a week, or a month? a. Achievement b. Long-range c. Cash d. Perpetual

A hotel has daily fixed room cleaning costs of $4,500. The hotels variable cost for room cleaning is $22.50 per room. What would be the hotels total room cleaning costs on a day when 175 rooms are to...

A manager just received a new price list for boxes from a supplier. It will now cost $ 1.00 a box for order quantities of SOI or more, $1.10 a box for 200 to 800, and $1.20 a box for smaller...

A jewellery manufacturer buys semi-precious stones to make bracelets and rings. The supplier has quoted a price of $8 per stone for order quantities of 600 stones or more, $9 per stone for orders of...

A company is about to begin production of a new product. The manager of the department that will produce one of the components for the product wants to know' how often his machine will be available...