Plot a scatter graph of the data

Assignment Help Applied Statistics

Reference no: EM131476599

Portfolio Task 1 -

(A) Find three examples of statistical charts/diagrams/graphical data displays from business management publications/media/research etc. You should write a paragraph on each statistical chart etc, specifically with reference to Zelazny's presentation & interpretation framework covered in the course and in Zelazny's book (see course reading list in course guide) and discuss the following points: BOOK TO READ: Say it with Charts, Gene Zelazny, McGraw-Hill, 2007 Section 1 and Section 2

(B) Do your chosen examples follow Zelazny's framework for charts? If not, why not?

(D) Produce new charts with effective messages to comply with Zelazny's framework where your selected charts do not follow the framework and hence incorrect. Approximate scales for your redrawn charts are acceptable.

No two charts should be similar in your selection of three charts.

(F) Find a suitable example and turn a routine statistical story into one which is more meaningful and with a much stronger storyline and with more effective use and interpretation of data. Apply the techniques and guidelines for making data meaningful as given in the UN (United Nations Economic Commission for Europe 2009: Website). publications listed in the reading list in the course guide. A routine statistical story in at least two pages should be reduced effectively to about one page approximately. You are not required to include charts in your improved statistical story.

Portfolio Task 2 -

It seems reasonable to assume that the price of a car is dependent on its age. Decide on a particular type of a car and model (engine, diesel, hybrid, electric etc.) and a suitable source for the data, such as your local newspaper, auto trade magazine etc. Collect data on the age and price of around 30 cars of the same type but of different age. Use Excel or any other statistical software package to do the following:

(a) Plot a scatter graph of the data. Does the scatter graph indicate that a linear relationship exists for all or part of the range of the data?

(b) Obtain the regression equation that would enable the price of the car to be obtained given its age.

(c) Using the equation obtained in (b) above and suitable examples, illustrate how the price of a car could be found if its age was known. Within what age range is your equation valid? Why is this so?

(d) What proportion of the variability in price is explained by the age factor?

(e) Using regression in Excel Tool Pak Add-in or any other statistical software interpret any p-value and explain its use along with the t-test value. What do confidence intervals in the solution tell you?

(f) Investigate whether other factors, such as size of the engine etc, would improve the fit of the regression equation.

Reference no: EM131476599

Questions Cloud

Business for opening a business in a foreign country : Create a research paper that lists and explains the methods available to a business for opening a business in a foreign country.

Create the strategic plan powerpoint presentation : Create the Final Strategic Plan. The Final Strategic Plan contains the elements of all the previous weeks' components and incorporates instructor feedback.

Relationships with consumers across the globe : What other technologies are helping marketers build relationships with consumers across the globe?

Discuss about the components of staffing : Why is it important for the organization to view all components of staffing (recruitment, selection, and employment) from the perspective of the job applicant?

Plot a scatter graph of the data : Plot a scatter graph of the data. Does the scatter graph indicate that a linear relationship exists for all or part of the range of the data

Discuss offering information regarding their special loans : Suppose that your local bank has a data mining system. The bank has been studying your credit and debit card usage patterns. Noticing that you make many.

Determine the most likely state sequence : Determine the most likely state sequence, and indicate which of the readings should be ignored (since they correspond to failure states).

Adapting a marketing offer for international markets : What are the five approaches to adapting a marketing offer for international markets?

Project planning and management : Research a current event from within the last five years that relates to this week's topic.

Reviews

len1476599

4/27/2017 8:11:58 AM

Topic: Business Analysis (Statistics). Detailed Question: Portfolio 1. Question A: BOOK TO READ: Say it with Charts, Gene Zelazny, McGraw-Hill, 2007 Section 1 and Section 2. Portfolio 1. Question F: (United Nations Economic Commission for Europe 2009: Website). Both the book and UN page are online. Original story in full (and not links) must also be included along with your improved attempt.

Write a Review

Required(*) Message

User Account

All Pages