StudentShare
Contact Us
Sign In / Sign Up for FREE
Search
Go to advanced search...

Applewood auto group - Coursework Example

Cite this document
Summary
a. To create the frequency distribution by the location for the vehicles sold, each location gets a code (1 for Toinesta; 2 for Sheffield; 3 for Kane; and 4 for Olean). Then, the Excel function COUNTIF is used to create the frequency table (Anderson, Sweeney and Williams,…
Download full paper File format: .doc, available for editing
GRAB THE BEST PAPER92.2% of users find it useful
Applewood auto group
Read Text Preview

Extract of sample "Applewood auto group"

Download file to see previous pages

The range for profits was calculated as a difference between the maximum and the minimum profit for each location. The results are presented in the table below. The last row presents the results for all sold vehicles (Black, 2012:52). 2. a. To construct the histogram for the profits, the Data Analysis toolkit is used. The option “Histogram” permits to create the table and the graph for the distribution of profits (Anderson, Sweeney and Williams, 2014:106-180). b. The results show that the data is normally distributed with the small sqewness.

The most frequently obtained profit is between $ 1,800 and $ 2,000. The rarest profits are within the range between $ 294 and $ 900. The profits of more than $ 3,100 are also very rare. More than 70 % of profits are within the range of $ 1,200 and $ 2,800. 3. a. To build the boxplot for variable age, the option “Histogram” in the Excel Data Analysis Toolkit can be used (Anderson, Sweeney and Williams, 2014:106-180). The results are given in the table and in the graph below. The boxplot shows that the variable age is normally distributed.

The mean and the median are almost equal. The average age of the buyer is 46 years. The most of the buyers are in the age between 33 and 60 years. The youngest buyer has 21 year and the oldest buyer is 73 years old. b. The data on the graph does not support the idea that the older buyers purchase cars on which the higher profits can be earned. It is seen from the scatterplot that buyers purchasing vehicles on which the high profits can be earned are in every age group. The scatterplot does not show the presence of the relationship between the age of the buyer and the earned profit. c. The option “Add Trend Line” in Excel can be used to get the trend line and the coefficient of determination.

The coefficient of determination R2 is equal 0.0684. The correlation coefficient is the square root of the coefficient of determination R = 0.2615. The results

...Download file to see next pages Read More
Cite this document
  • APA
  • MLA
  • CHICAGO
(“Applewood auto group Coursework Example | Topics and Well Written Essays - 1000 words”, n.d.)
Applewood auto group Coursework Example | Topics and Well Written Essays - 1000 words. Retrieved from https://studentshare.org/mathematics/1691411-applewood-auto-group
(Applewood Auto Group Coursework Example | Topics and Well Written Essays - 1000 Words)
Applewood Auto Group Coursework Example | Topics and Well Written Essays - 1000 Words. https://studentshare.org/mathematics/1691411-applewood-auto-group.
“Applewood Auto Group Coursework Example | Topics and Well Written Essays - 1000 Words”, n.d. https://studentshare.org/mathematics/1691411-applewood-auto-group.
  • Cited: 0 times

CHECK THESE SAMPLES OF Applewood auto group

Business article (Auto Bailouts)

based The Cons of Continuously Supporting auto Bailouts during Financial Crisis For more than a decade, the automobile industry in the United States is one of the largest business groups that has significantly affect the economy and socio-cultural aspect of people around the world.... based automobile companies were receiving auto bailouts during financial crisis.... This is the main reason why most of the Americans oppose the idea of auto bailout....
2 Pages (500 words) Essay

Super Cheap Auto Group Limited

Super Cheap auto group Limited is a retailer of car products.... The company has… From the financial reports of the company it is clear that Super Cheap auto has changed its source of financing and currently uses higher levels of debt to fund its operations.... The calculation of the CAPM highlights that Super Cheap auto pays out a higher level of return than the market while the minimum return expected by the shareholders is 9.... Super Cheap auto deals with retailing of cars in Australia and New Zealand....
8 Pages (2000 words) Essay

Mathematical Skills for Business

Thus, Applewood auto group's marketing departments belief that younger buyers purchase vehicles on which lower profits are earned and the older buyers purchase vehicles on which higher profits are earned is correct.... Based on the above analysis, the Applewood auto group should go ahead with the advertising campaign as planned.... Therefore, the Applewood auto group's marketing department should use this information as part of an upcoming advertising campaign to try to attract older buyers on which the profits tend to be higher....
4 Pages (1000 words) Essay

Managing the Supply Chain in the Auto Industry

This is a very important aspect in the auto industry due to various reasons.... It is imperative to establish if One economic aspect of the auto industry that I find most interesting or most significant is about managing the supply chain.... This is a very important aspect in the auto industry due to various reasons.... This also constitutes the supply chain of the auto industry....
2 Pages (500 words) Essay

Midlands Auto-Parts Limited

This report “Midlands auto-Parts Limited” is aimed to provide a detailed analysis of requirements of the system as well as goals for which this system needs to be developed.... hellip; The author of the paper states that Midlands auto-Parts Limited is doing business as a retailer of Motorcar parts and supplies accessories to the public.... idlands auto-Parts Limited (MAP Ltd) is doing business as a retailer of Motorcar parts and supplies accessories to the public....
8 Pages (2000 words) Assignment

International Business: The problem of Auto Sales Soar in India and Global Consequences of Dubai's Debt

This paper "International Business: The problem of auto Sales Soar in India and Global Consequences of Dubai's Debt" contains two essays that demonstrate the problems of international business such as auto sales soar in India and the global consequences of Dubai's debt problem....
8 Pages (2000 words) Essay

Super Cheap Auto Group Limited

This paper "Super Cheap auto group Limited" presents Super Cheap auto group Limited that has grown and expanded steadily since inception in 1974.... hellip; The cost of equity of Super Cheap auto group Limited can be computed as follows.... Reg and Hazel founded Super Cheap auto group Limited in 1972 and diversified in 1978 to include Goldcross Cycles.... Super Cheap auto group Limited diversified further to Boating, Camping, and Fishing in 2003....
8 Pages (2000 words) Case Study

The Phenomenon of Autoethnography

The natives tried to express themselves in the language in which the oppressors' group could understand.... This paper ''auto-ethnography'' tells that Pratt defines a contact zone as a meeting space of two or more cultures.... ratt explains autoethnography as a genre of resistance, where the auto ethnographer represents his/her culture from its perspective....
5 Pages (1250 words) Essay
sponsored ads
We use cookies to create the best experience for you. Keep on browsing if you are OK with that, or find out how to manage cookies.
Contact Us