Statistical Analysis Of Sales

2418 words - 10 pages

Tom’s Classic Mustangs
Statistical Analysis of Sales
Leadership and Organizational Behavior

We have been asked to analyze nine different variables to determine what if any, relationship they may have against the selling price of used Ford Mustangs at Tom’s Classic Mustangs. We have been provided data for the last 25 Mustangs sold by Tom’s. Please see Appendix A for the raw data.
We will be taking the data for each variable, determine a hypothesis between the variable and the selling price, then test to prove or disprove the hypothesis. A conclusion will be drawn from the test.
Finally, after all the variables have been tested against the selling ...view middle of the document...

Error |3541.151 |Dep. Var. |PRICE | | |
| | | | | | | |
|ANOVA table | | | | | | |
|Source |SS |df |MS |F |p-value | |
|Regression | 72,887,081.1429 |1 |72,887,081.1429 |5.81 |.0216 | |
|Residual | 413,811,868.4000 |33 |12,539,753.5879 | | | |
|Total | 486,698,949.5429 |34 |  |  |  | |
| | | | | | | |
| | | | | | | |
|Regression output | | | |confidence interval |
|variables | coefficients |std. error | t (df=33) |p-value |95% lower |95% upper |
|Intercept |7,281.2000 |708.2303 | 10.281 |8.05E-12 |5,840.2946 |8,722.1054 |
|CONVERT |3,194.4000 |1,324.9775 | 2.411 |.0216 |498.7129 |5,890.0871 |

Conclusion: The P-value of 0.0216 is smaller than our significance level of 0.05. Therefore, we reject the null and accept the alternate hypothesis. We conclude that there is a significant relationship between the variable of convertible and the selling price.

Variable 2
Transmission type against selling price

Null hypothesis: There is no relationship between transmission type and selling price.
Alternate hypothesis: There is a relationship between transmission type and selling price.

|Regression Analysis | | | | | |
| | | | | | | |
| |r² |0.022 |n |35 | | |
| |r |0.147 |k |1 | |...

Other Essays Like Statistical Analysis of Sales

Res 342 Week 4 Essay

1381 words - 6 pages RES/342 Week Four Regression analysis in Research INTRODUCTION Have you ever had to forecast sales? Have you ever wondered if there was a positive relationship between the number of hours that you studied for a certain exam and your final course grade? Have you ever wondered if there was a negative relationship between the number of cups of caffeinated coffee that you consume in a given day and the incidence of developing gallstones

Chapter 1 Marketing Research Methodological Foundations 10th Edition Iacobucci and Churchill

1348 words - 6 pages , by brand, by market segment, or by geographic area. c. by research technique or approach such as sales analysis, mathematical and/or statistical analysis, field interviewing, or questionnaire design. d. by marketing function performed, such as field sales analysis, advertising research, or product planning. e. by type of computer equipment used, such as by mainframe, by PC, or by laptop units. c 17

Doc, Docx

1589 words - 7 pages Semester Project Income Statement Analysis of Regional Distribution, INC. Date Submitted: 11/30/2012 Submitted by: Jingwen Tang 103802116 Shiya Wang 103801968 Xinyue Zhang 103683797 Hongyang Xu 103667508 Mathew Nigel Contents I. Introduction……………………………………………………….2 II. Analysis…………………………………………………..……….2 a. Determine Regional Distribution’s break-even point in sales dollars

Forecasting and Environment Forecasting

1027 words - 5 pages – Regular supply of material, Maximum utilization of machines, Regular availability of labour Formulation of pricing policy Proper control of sales Arrangement of finance Production capacity Labour requirements Long term objectives • Capital restructuring and resourcing Steps in forecasting demand Determining the objectives Period of forecasting – Short term or long term Collection and analysis of data – data to be collected, tabulated, analyzed


2687 words - 11 pages a forecast. Overview of qualitative methods a) Jury of executive opinion (Panel consensus): The opinions of a group of high – level experts or managers, often in combination with statistical models are pooled to arrive at a group estimate of demand. b) Sales force composite (Grassroots techniques): Each sales person estimates what sale will be in his or her region. These forecasts are then reviewed to ensure that they are realistic. c

Accounts Receivable Turnover and Dso

1045 words - 5 pages , we can translate this into days by dividing it into 365: 365/7.3 = 50. This number is known as Days Sales Outstanding (DSO.) It represents the average amount of time that elapses after a sale is made before Plantronics collects the proceeds from its customers. For more information, see all articles on: Financial Statement Analysis, Fundamental Analysis, Investing in Stocks, Ratio Analysis, Security Selection Accounts Receivable Turnover

Synopsis: The Effect of IMC on Brand Image of Laptops/Notebooks

485 words - 2 pages a marketing mix to achieve synergy and the relationship between IMC implementation performance and brand image.Data collection methods used in the research project:In this research project, questionnaires were collected from consumers and a questionnaire survey analysis was performed. Upon the completion of the questionnaire survey analysis of consumers' viewpoint through statistical data analysis method, it is believed that the results, to find

Business Research

973 words - 4 pages Chapter 4 Key Terms and Discussion Questions Census- is a count of all elements in a population. Data- information collected from participants, by observation, or from secondary sources. Data analysis -editing, reducing, summarizing, looking for patterns, and applying statistical techniques to data Decision rule- criterion for judging the attractiveness of two or more alternatives when using a decision variable. Decision variable- is a

Managing with Analytics at Procter

802 words - 4 pages performance by brand, initiative, retailer, and, in some cases, individual store * Compacted detergents were set to be introduced throughout the rest of North America in the coming months and Torres was cautiously optimistic about the impact they would have on the overall market and on P&G sales, Torres wondered whether he should override the statistical models and increase the forecasts. * The company marketed approximately 300

Math Student

2460 words - 10 pages chapter, you should be able to : Describe or Explain: Moving averages  Exponential smoothing  Trend projections  Regression and correlation analysis  Measures of forecast accuracy  4-6 Forecasting at Tupperware Each of 50 profit centers around the world is responsible for computerized monthly, quarterly, and 12-month sales projections These projections are aggregated by region, then globally, at Tupperware’s World

Valuation of Bonds

2275 words - 10 pages statements as descriptive variables. Studies suggest there is empirical evidence that support the further evaluation of profitability, liquidity, and cash flow as the most important variables in predicting success or default. Referencing back to Beaver and Altman, the most commonly used statistical models to evaluate accounting and market or industry based variables have been logistic regression and discriminate analysis (Ameur 2007). Findings from

Related Papers

Statistical Analysis Of Foreign Direct Investment In India

2854 words - 12 pages Sensex & Nifty correlation is applied. The multiple regression analysis is a statistical technique used to evaluate the effects of two or more independent variables on a single dependent variable. In the current paper attempt is made to study the impact of FDI & FII on Sensex and Nifty. So FDI & FII are considered as the two independent variables the dependent variable for model 1 is Sensex and Nifty for model 2. Model Building: Further, to

Statistic Essay

797 words - 4 pages : 1. Statistics and planning: Statistics in indispensable into planning in the modern age which is termed as “the age of planning”. Almost all over the world the government are re-storing to planning for economic development. 2. Statistics and economics: Statistical data and techniques of statistical analysis have to immensely useful involving economical problem. Such as wages, price, time series analysis, demand analysis. 3. Statistics and

Selection Of Sales Manager For Fortune 500

994 words - 4 pages goal drive with a respect and knowledge of sales systems: processes, tools, and skills. • A moderated detail-orientation to allow for analysis within a big picture orientation. • A moderated need to nurture - ability to hear an individual’s needs and yet keep time management a priority. • Willingness to understand and adapt communication and coaching to different personality styles. • Out of the box thinker and creative problem solver

Case Study Vintage Restaurant

606 words - 3 pages Food Sales). Perform an analysis of the sales data for the Vintage Restaurant. Prepare a report for Karen that summarizes your findings, forecasts, and recommendations. Include: a. A graph of the time series. b. An analysis of the seasonality of the data. Indicate the seasonal indexes for each month, and comment on the high and low seasonal sales months. Do the seasonal indexes make intuitive sense? Discuss. c. A forecast of sales for January