Define right selling and buying strategy, Basic Statistics

Assignment Help:

Mr. Palsson plans to buy a MacBook Pro which can hold the 6GB of RAM (he has a 4GB chip laying around, so he doesn't care what RAM is actually in the computer, as long as the computer can handle 6GB), swap the computers' hard drives, and then sell his current computer, with the hard drive from the upgrade computer. To clarify: First he will buy computer off eBay that meets his upgrading needs. He will then swap the hard drives. Finally he will sell his old computer with the hard drive from the computer he just bought. This will save him a lot of installing software hours!

Mr. Palsson is married to an operations research specialist, who quickly realizes that regression can help with his decision problem. At the same time the OR wiz realizes (although she decides not to tell him) that Mr. Palsson may not have collected the best data - but it would have to do. Some of it may even have to be thrown out - but such are the realities of Data and Modeling.

The Assignment

Using the data on successful transactions (actions that ended in a sale), build a regression model(s) to assist Mr. Palsson with upgrading his computer.

Word of advice! Be selective about how you model your variables. Mr. Palsson has not provided us with too many data points, so the data cannot support fitting over 30 variables - so I suggest, for example, not creating a dummy variable for each day of the week!1 Use your judgment and be selective. In addition, with few data, but many variables, pay attention, not only to R2 but adjusted R2 as well. In the end you should have a model were the signs of the coefficients make intuitive sense (for the most part)2.

Part a)

Using data on successful (result=1) auction style (type equals 1, 2, 5 or 6) transactions, build a model that predicts the sale prices of a MacBook Pro based on the data Mr. Palsson has collected. Provide a printout of your model and label it as Exhibit 3-a. (Note: there are multiple possible successful models here. Please only include information about ONE model, the one you deem best to use).

Explain or provide justification for data modeling and/or nonlinear transformations you use in your model in the space below. If you want to submit supporting Exhibits, please label them etc. and clearly list them in the space provided below. The Exhibits should be self-explanatory - the grader should not need to guess what they mean.

1 Perhaps a good rule of thumb is for your dummy variables to have no less than five observations of both values (zero or one)

2 This question is not meant to be a tricky exam problem addressing nonlinear transformations.

Part b)

Please answer the following questions based on your model in part a) in the space provided.

Based on your model what can mr. Palsson expect to pay for a upgrade computer if he buys it in an auction style listing (assume he buys one with a 250GB hard drive, in a good condition)?

Based on your model what can he expect to get for his computer if he lists it in a auction style format (assume he sells his computer with a 250GB hard drive)?

What is the right selling and buying strategy for Mr. Palsson if he utilizes auction style listings?

Part c)

Using data on transactions that finished with buy-it now (result=2), use your model from a) to analyze how the ending prices in a buy it now format compare to auction style (HINT: how much would you expect these computers to sell for if listed auction style). Create an exhibit that summarizes your findings and label it Exhibit 3-b.

Should Mr. Palsson utilize the "buy it now" format for either buying or selling a computer? Briefly explain your reasoning.

Part d)

Assume the upgrade computer mr. Palsson buys has a 250GB hard drive. Using your analysis so far (and any additional analysis you chose to conduct), is it worth it for Mr. Palsson to buy a new 500GB hard drive for $90 to insert into his old computer before selling it, rather than to just put in the 250GB hard drive from the upgrade computer? Briefly explain


Related Discussions:- Define right selling and buying strategy

#tiMEDIANtle.., #quHOW TO MAKE ASSIGMENT ON MEDIANestion..

#quHOW TO MAKE ASSIGMENT ON MEDIANestion..

Management accounting, Q. CRSL has a large auditorium which can cater for ...

Q. CRSL has a large auditorium which can cater for 300 people and is ideal for formal balls and functions. The auditorium can also be reconfigured to cater for 100 people. The Sea

Comb & proportions type will appear in f & f2, In fowl,the genotype rrpp gi...

In fowl,the genotype rrpp gives single comb, R_P_ walnut comb, rrP_ pea comb, and R_pp rose comb. a. What comb type will appear and in what proportions in F and F2 if single- co

Group project in statistics, I) Introduction 1) Topic (s) 2) Survey Questi...

I) Introduction 1) Topic (s) 2) Survey Question 3) Type of Sampling 4) Why? II) Calculations 1) Data Analysis (Charts, sample mean, sample standard deviation) 2) Probability 3) E

Time series, what are the uses of time series

what are the uses of time series

Explain correlation coefficients, 1. What type of correlation coefficient w...

1. What type of correlation coefficient would you use to examine the relationship between the following variables? Explain why you have selected the correlation coefficients. A.

Functions , i need help it says for the tables of values determine appropri...

i need help it says for the tables of values determine appropriate veiwing window, create a scatter plot, write a function rule, and graph your funtion rule over your scatter plot

BUSINESS FORECASTING., a) What is analysis of variance? What are the assump...

a) What is analysis of variance? What are the assumptions of this technique? b) Three samples below have been obtained from normal populations with equal variances. Test the hypoth

Projectile, a ball is projected so as to attain a maximum range. Find the m...

a ball is projected so as to attain a maximum range. Find the maximum height attained if initial velocity is u

Write Your Message!

Captcha
Free Assignment Quote

Assured A++ Grade

Get guaranteed satisfaction & time on delivery in every assignment order you paid with us! We ensure premium quality solution document along with free turntin report!

All rights reserved! Copyrights ©2019-2020 ExpertsMind IT Educational Pvt Ltd