Premium Essay

Statistical Analysis of Sales

In:

Submitted By bsbb
Words 2404
Pages 10
Tom’s Classic Mustangs
Statistical Analysis of Sales
Leadership and Organizational Behavior

Introduction 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 price, we will develop a multiple regression model of the selling price on the variable in the data set to determine which are significant and how the significant variables affect the price.
Please note the following: • All analysis is based on the given data set. • All hypotheses are based on a confidence level of 95%. • Each variable group is tested against the same selling price data.

Part I
Variable 1 Convertible against selling price

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

|Regression Analysis | | | | | |
| | | | | | | |
| |r² |0.150 |n |35 | | |
| |r |0.387 |k |1 |

Similar Documents

Premium Essay

A Reportonquestionnaire Development & Statistical Analysisofapex Spinning and Knitmills Limited

...A ReportOnQuestionnaire Development & Statistical AnalysisOfApex Spinning and Knitmills Limited | LETTER OF TRANSMITTAL Mr. A Lecturer Department of Finance University of Dhaka. Subject: Submission of Course Report Honorable Mam, It is a great pleasure for us to submit the report on “Questionnaire Development & Statistical analysis of Apex Spinning and Knit Mills Limited” as per our requirement for course F-110; Business Statistics. Writing this report has been a challenging yet interesting experience for us. It enabled us to grasp a thorough knowledge on the subject matter and we are confident that this knowledge will prove to be of utmost value and importance to us in future. We have undertaken our sincerest effort for successful completion of this report and we hope that any unintentional error, omission or mistake committed by us while preparing this report will be considered with sympathy. Therefore, we beg your kind consideration in this regard. We will be very grateful if you accept our report and oblige there by. Sincerely, Group 9 Kazi Golam Rabbani Mowla 18-001 | | Md.Mahfujur Rahman 18-005 | | S. M. Imtiaz Bhuiyan 18-027 | | Md. Tareq Sojol 18-031 | | Tanvir Hasan 18-105 | | Md. Shalehin ...

Words: 4694 - Pages: 19

Premium Essay

Big Suzy Snack Cake

...Date: November 4, 2012 Ye Olde FoodKing Company From: Re: Big Suzy’s Snack Cakes Regression Analysis Introduction The Regional Food Manager for Ye Olde FoodKing Company has retained Mark Craig of Blue Steel Consulting to perform a regression analysis to forecast demand of your product. The four characteristics readily available included price, competitors’ price, average income, and market population. The results of each regression analysis are presented at the end of this memo. The remainder of this memo describes the regression analysis used and limitations to the data available. Running a regression provides a statistical procedure to estimate the liner dependency of one or more independent variables on dependent variables. Confidence that the true (population) relation between X and Y lies between “Lower” and “Upper” Methodology * Form a theoretical model of the relationship under consideration. * This model suggests what explanatory variables to include in the analysis. * Collect data on independent and dependent variables. * Estimate regression line. * Examine results. This includes test of statistical significance and analysis of residuals. Regression Analysis Regression analysis is a statistical technique that examines the relation of a dependent variable to specified independent variables. The easiest form of regression analysis involves finding and understanding the straight-line relationship to illustrate the variation in...

Words: 1333 - Pages: 6

Premium Essay

Finance

...Statistical Tools for Financial Research Anna Hemmer University of Phoenix Statistical Tools for Financial Research The financial condition of an organization is identified through data provided in formal records called financial statements. Financial statements provide an accurate account of a company’s financial position and cash flow of the business. Stakeholders used the data to make decisions regarding future purchases, investments, and profitability of the organization. Analyzing financial statements consists of using various methods (statistical tools) including comparative statements, schedule of changes in working capital, common size percentages (analysis), fund analysis, trend analysis, and ratio analysis. The purpose of this paper is to review the financial statements of one domestic, and one global organization from the Financial Times 500. The two companies for review are the McDonald’s and Samsung organizations. The data provided in the financial statements will convert into a ratio analysis. Common size analysis, and accounting analysis limitations are tools for review. The pros and cons of each of these statistical tools will also be discussed. To understand the importance of statistical tools, a review of ratio analysis, common size analysis, and accounting analysis limitation will be the starting point for this paper. Ratio Analysis Ratio analysis is the most powerful tool of financial analysis (Accounting for Management, 2012, para. 1) used...

Words: 2386 - Pages: 10

Free Essay

Bsbmkg507A Interpert Market Trends and Developments

...Assessment 1 – Question and Answer 1. How would you use the following statistical analysis techniques to analyses market trends? a Conversion rate of leads to sales The conversion rate of leads to sales is very common way of measuring marketing performance. The mail advantage of this measuring is to track customer numbers and receipts, to gather data automatically. Sales conversion is also a good place to begin discussion of statistical analysis and its application. This measure is perhaps the simplest to define. This is the percentage of sales leads that and organization is able to convert into sales b Average order value or average response rate A good example of measure central tendency is a figure such as average order value. This figure would look at the order value of all your customers and use it to determine how much on an average your customers tend to spend in your establishment which is usually available and stored into your accounting systems. c Sampling * A sample is the group of people who take part in the investigation The people who take part are referred to as “participants” * Sampling is the process of selecting participants from the population. * The target population is the total group of individuals from which the sample might be drawn. * In some types of research, the target population might be as broad as all humans, but in other types of research the target population might be a smaller group such as teenagers, elderly, adults...

Words: 672 - Pages: 3

Premium Essay

Forecasting

...TOPIC 1. FUNDAMENTALS OF ECONOMIC FORECASTING TOPIC I TOPIC I. FUNDAMENTALS OF ECONOMIC FORECASTING   Contents 1. Meaning of forecasting 2. Features, importance and limitations of forecasting 3. Forecast types   1. Meaning of forecasting Forecast is a likely, scientifically well-grounded opinion about the possible state of the events, objects or processes in the future. Forecasting is a process of making statements about events whose actual outcomes (typically) have not yet been observed. Forecasting is a process of predicting or estimating the future based on past and present data. Economic Forecasting is a process of making forecasts based on analysis of past trends and regularities of the economic processes. Economic forecasts can be carried out at a high level of aggregation – for example for GDP, inflation, unemployment or the fiscal deficit – or at a more disaggregated level, for specific sectors of the economy or even specific companies. Economic forecasting provides information about the potential future events and their consequences for the organization. It may not reduce the complications and uncertainty of the future. However, it increases the confidence of the management to make important decisions.   Economic forecasting includes the following steps: 1. Identifying items to be forecast. The items of socio-economic forecasting are the economic processes (for example, inflation, demand, supply), any indicator describing the company activity (for example...

Words: 17426 - Pages: 70

Premium Essay

Marketing Research

...for their likes, dislikes, needs, and wants in a one-on-one situation. b. spans the informational boundary between the firm and its environment. c. can only be employed to assess the impact of past or contemplated adjustments in the marketing mix. d. is most generally used for marketing control purposes. e. is b and d. c 3. Which of the following is NOT a common activity of a marketing research department? a. assessing the impact(s) of changes in the marketing mix for a good marketing promotion b. identifying the legal constraints on advertising c. determining the most efficient production sequences for a plant d. establishing sales territory quotas e. c and d c 4. Which of the following is FALSE? a. The basic purpose of marketing research is to assist marketing managers in making more informed decisions. b. Marketing research became a significant business activity after World War II when the economy changed from a production orientation to a consumption orientation. c. Marketing research as an organizational function was adopted by most firms when they could no longer satisfy demand for their products. d. a and b. e. a, b and c. a 5. Marketing research a. involves the use of information to make better...

Words: 1331 - Pages: 6

Premium Essay

Demand Estimation and Forecasting

...Managerial Economics Sat. 11:00 – 14:00 Demand Estimation and Forecasting Facilitators : Mr. John Michael G. Favila Mr. Jose Miguel G. Catan Learning Objectives * Identify a wide range of Demand Estimation and Forecast Methods. * Understand the nature of Demand Function * Understand that the Demand Estimation and Forecasting is all about minimizing risk. Demand Estimation and Demand Forecasting; distinguished. * Demand Estimation attempts to quantify the link between the level of for a product and the variables which determines it whereas the Demand Forecasting simply attempts to predict the level of sales at some particular future date. 7 stages of Demand Estimation 1. Statement of a Theory or Hypothesis : This usually comes from a mixture of economic Theory and previous empherical studies. 2. Model Specification : This means determining what variables should be included in the demand model and what mathematical form or forms such a relationship should take. 3. Data Collection : Gathering necessary information. a. Cross-sectional data : Provide information on a group opf entities at a given time. b. Time-serie data: Provide information on the entity over time. i. Quantitative: Data that are expressed in nominal in either ordinal or cardinal. ii. Qualitative: Expressed in categories. 4. Estimation of Parameters : This means computing the value of the coefficient...

Words: 1676 - Pages: 7

Premium Essay

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

...for their likes, dislikes, needs, and wants in a one-on-one situation. b. spans the informational boundary between the firm and its environment. c. can only be employed to assess the impact of past or contemplated adjustments in the marketing mix. d. is most generally used for marketing control purposes. e. is b and d. c 3. Which of the following is NOT a common activity of a marketing research department? a. assessing the impact(s) of changes in the marketing mix for a good marketing promotion b. identifying the legal constraints on advertising c. determining the most efficient production sequences for a plant d. establishing sales territory quotas e. c and d c 4. Which of the following is FALSE? a. The basic purpose of marketing research is to assist marketing managers in making more informed decisions. b. Marketing research became a significant business activity after World War II when the economy changed from a production orientation to a consumption orientation. c. Marketing research as an organizational function was adopted by most firms when they could no longer satisfy demand for their products. d. a and b. e. a, b and c. a 5. Marketing research a. involves the use of information to make better...

Words: 1331 - Pages: 6

Premium Essay

Sales Forcast

...should • Understand the principles of forecasting. • Know the differences between Time Series and Regression Analyses. • Understand how expert opinion, sales forces and consumer opinions can all contribute to better forecasts. * by Beverley Thompson, The University of Western Sydney, Nepean Demand Forecasting in Mar keting w 689 An important part of the marketing planning process is the setting of goals that are realistic and achievable, given a particular marketing environment and level of marketing commitment. In marketing, such goals are usually based on market share objectives and sales targets, both of which require accurate forecasts of total market size, market size of target segments and likely market share within a targeted segment. W H AT A R E W E F O R E C A S T I N G ? Accurate forecasting requires a clear definition of the market in question. Markets may be differentiated on the basis of the following variables. GEOGRAPHY A market may be defined at world, country, state, region, sales territory, town, store or customer level. When formulating a forecast or other marketing plans, the geographical dimension must be clearly indicated. Planning Coca Cola consumption for the year 2000 Sydney Olympics for example, will necessitate the forecasting of increased consumption for the Sydney sales region, but not necessarily for Brisbane. TIME A forecast must be defined for a specific time period. Initially several levels of forecast may be set...

Words: 4641 - Pages: 19

Premium Essay

Quantitative

...estimate one variable on the basis of another. • - Examples: Is there a relationship between the number of hours that student studies for an exam and the score earned? - Is there a relationship between years of employee experience and the quantity of production? - Is there a relationship between the product price and the purchasing amount of that product? - Is there a relationship between the amount of money spend per month on advertising and the monthly sales? - Is there a relationship between age and blood pressure ? Can we estimate, based on the amount of money spent on advertising in January, what is the sales in February will be? • - We begin this chapter by: Examining the meaning and purpose of Correlation Analysis. Then, We continue our study by developing a mathematical equation that help us to estimate the value of one variable based on the value of another. This is called Regression Analysis. What is Correlation Analysis? • Example: Number of sales calls and copiers...

Words: 1149 - Pages: 5

Premium Essay

Business Administration

...ones are most effective. We review this evidence in order to provide guidelines for forecasting for marketing. The coverage includes intentions, Delphi, role playing, conjoint analysis, judgmental bootstrapping, analogies, extrapolation, rule-based forecasting, expert systems, and econometric methods. We discuss research about which methods are most appropriate to forecast market size, actions of decision makers, market share, sales, and financial outcomes. In general, there is a need for statistical methods that incorporate the manager's domain knowledge. This includes rule-based forecasting, expert systems, and econometric methods. We describe how to choose a forecasting method and provide guidelines for the effective use of forecasts including such procedures as scenarios. INTRODUCTION Forecasting has long been important to marketing practitioners. For example, Dalrymple (1987), in his survey of 134 U.S. companies, found that 99 percent prepared formal forecasts when they used formal marketing plans. In Dalrymple (1975), 93 percent of the companies sampled indicated that sales forecasting was one of the most critical' aspects, or a ‘very important’ aspect of their company's success. Jobber, Hooley and Sanderson (1985), in a survey of 353 marketing directors from British textile firms, found that sales forecasting was the most common of nine activities on which they reported. Managers' forecasting needs vary...

Words: 10312 - Pages: 42

Premium Essay

Financial Managent

...overview of the database used to give us data necessary in conducting statistical analysis. We feel it best to provide the perspective that we have of statistical analysis to you to insure that we are all on the same page. All data provided surrounds the analytical study provided in report of the probability distribution. Memo To: American Intellectual Union From: R. E. Smith, HR Manager of Kaplan University Date: 8/ 3/13 Subject: Statistical Analysis by Probability Distribution Dear Sir/Mam: By use of the database you provided to help us in the conducting of statistical analysis using probability distribution, we have produced the following information. Overview of the Data Set In performing this analysis using the data set, we have decided to use both qualitative and quantitative variables. These qualitative variables are categorized demographically by gender, age, department, position and tenure, and the quantitative variables are categorized by overall job satisfaction by intrinsic and extrinsic job satisfaction providing a measure on a scale of 1 – 7 of satisfaction with actual performance. Use of Statistics and Probability in the Real World In describing statistics, they are identified as numbers summing up information that keep us informed about the world around us by use of sales reports, health risk data, national trends, and news headlines to name a few. These statistical numbers are used to set policy, and even make determinations. They...

Words: 1290 - Pages: 6

Premium Essay

Web Analytic

...as the scientific process of transforming data into insight for making better decisions. It is the combination of skills, technologies, applications and processes used by data scientist to gain insight in to their business based on data and statistics to drive business planning. It typically use’s data, statistical and quantitative analysis to measure the performance of the subject (Organization/ website etc.) on which a study is to be conducted. Analytics can be used in various fields such as market research, for studying user web pattern behavior & in many other applications to derive some meaningful information out of the complex world around us. But we will first touch upon the area of operations research & how Analytics with the help of various statistical tools can help to solve the operation related problem in an organization. Operations research overlaps with other disciplines, such as industrial engineering and operations management. It is often concerned with determining an optimal solution out of a business problem. It may either to maximize your profit, performance, or yield or minimize your losses, risk, or cost. In the fields of production, logistics, or sales where managers are facing a problems so as how to allocate resources, develop production schedules, manage the supply chain, and set prices. For example, it many help to decide how to organize products in supermarkets or help companies figure out the most effective way to ship and distribute products...

Words: 1057 - Pages: 5

Premium Essay

Performance Lawn Equipment Report

...Section 10 Group 6 Table of Contents Assignment Summary 3 Chapter 3 | Part I: Business and Market Overview 4 a) Dealer Satisfaction Analysis 4 North America 4 South America 4 Europe 4 Pacific Rim 5 China 5 C) Complaint Submissions Analysis 6 f) On-time delivery 6 g) Defects after delivery 7 h) Response time 7 Chapter 3 | Part II: Shipping Cost Analysis 7 Chapter 3 | Part III: Customer Survey Overview 8 Chapter 4: Detailed Statistical Information 12 a) Dealer, End-User Mean and Standard Deviation Analysis 12 Dealer Satisfaction Trends 12 End-User Satisfaction Trends 14 b) Descriptive Statistical Summary 16 c) Quarterly Response Time Analysis 17 d) Defects after Delivery Overview: Last 5 Years 18 e) PLE vs. Industry Mower and Tractor Sales Analysis 20 PLE vs. Industry Sales of Mowers 20 PLE vs. Industry Sales of Tractors 21 Appendix 23 Assignment Summary Week 1 | Assignment #1 due on 5/17/15 by 11:59PM PST | Chapter Required | Sub section | Chapter 3 | Part 1.a | Chapter 3 | Part 1.c | Chapter 3 | Part 1.f | Chapter 3 | Part 1.g | Chapter 3 | Part 1.h | Chapter 3 | Part 2 | Chapter 3 | Part 3 | Chapter 4 | a | Chapter 4 | b | Chapter 4 | c | Chapter 4 | d | Chapter 4 | e | Chapter 3 | Part I: Business and Market Overview a) Dealer Satisfaction Analysis Through the evaluation of submitted dealer satisfaction responses PLE can generate and employ strategies to encourage heightened operational...

Words: 4360 - Pages: 18

Premium Essay

Statistic

...Term Paper Guideline STAT 500 Length: Less than 1500 words Format: Cleanly typed Students are required to write an article describing a statistical method that will solve a business or management problem; or an creative approach that mainly rely on statistical methods that would advance the current practice. The statistical method involved may or may not relate to statistical concepts or methods covered in the course. Students are encouraged to conduct their own literature research. Information collected from books, magazines or newspapers are acceptable, including any of those found in UNVA’s eLibrary. Students could invent their own practical and feasible solutions to some real issues they experience in their work, though not required. The article should describe well the background of the problem and each of the steps in solving the problem. The length of the article should be within 1500 words; visual aids, such as tables, charts, graphs should be included where necessary. Some business statistics applications example include • Select profitable stocks • Detect fraudulent claims • Score an applicant’s credit • Discover cross-selling opportunities for products • Quantify drug efficacy • Forecast new product sales • Discover new customers • Recognize objects in images • Verify identity through biometrics; and • Anticipate shifts in market sectors for hedge funds • Set individual...

Words: 430 - Pages: 2