Share
Explore BrainMass

Scatter Plot

A scatter plot is utilized to depict the relationship between two variables and can analyze whether a cause-and-effect relationship exists. When using a scatter plot, commonly the variables being plotted on the y and x axes are related to each other. Furthermore, useful inferences and conclusions can be drawn when the y variable is dependent upon the x variable.

In comparison to other statistical figures, the points plotted on a scatter plot are not joined by a straight or curved line. However, in some instances the points may form a straight line. When this results, this means that there is a strong correlation between the two variables.

Using scatterplots, both positive and negative relationships can be observed. In some cases the points being plotted may just be randomly scattered and this is indicative of two variables which are not correlated at all. In addition to depicting whether a linear relationship exists between two variables, a scatter plot can also indicate whether outliers exist within a data set.

For example: Is there a correlation between age and the time spent watching TV? In this case, the time (in hours) is the dependent variable and age (in years) is the independent variable. Age is the independent variable because it changes on a yearly basis and this is not influenced by other factors. Time is the dependent variable in this case. Even though time stands alone, the amount of time spent watching TV will change during different stages of an individual’s life.

Figure 1. This scatter plot examines whether a relationship exists between the age of individuals and the time they spend watching TV. Results for individuals up to the age of 18 were recorded and the total sample size (n) = 80.

As can be observed from Figure 1, there is no correlation between the two variables being analyzed. Scatter plots provide a simple way of visually testing the correlation between different factors and thus, being able to use them properly is a valuable skill.

Hypothesis Testing and Regression Analysis Calculations..

1.) Refer to the real estate data. Determine whether there is a difference in the mean selling price of homes with an attached garage and homes without an attached garage. Homes with an attached garage A.) Mean = B.) Standard Deviation = C.) Number = Homes without an attached garage D.) Mean = E.) Standa

Descriptive Statistics, Hypothesis Test, and Linear Regression

I have attached the questions in the document below. Please only complete task 2a, task 2b and task 3. For 2a, calculate the following: the mean, mean deviation, standard deviation, median, and mode. The calculations for task 2a have to be for grouped data. This means that you must calculate it per grouped data formulas wh

Scatter Plot in Excel

Here is the data: Mean daily calories | Infant Mortality Rate (per 1,000 births) 1523 | 154 3495 | 6 1941 | 114 2678 | 24 1610 | 107 3443 | 6 1640 | 153 3362 | 7 3429 | 44 2671 | 7 a) For the above data construct a scatter plot using SPSS or Excel. What does the scatter p

Poverty Level and School Passage Rate

It has long been known that a student's ability to pass the state's fourth-grade proficiency tests is closely related to the income level in the student's home. The accompanying chart shows how individual elementary schools performed in the March 2000 proficiency tests in fourth-grade math and readingâ?"and whether the schoo

Scatter Plot and data

Show all steps used in arriving at the final answers. Incomplete solutions will receive partial credit. Data for a sample of houses sold recently in the suburb of a large metropolis are given below: Area of House (hundreds of square feet) Selling Price (thousands of dollars) 20 250 19 220 27 350 28 390 30 320 15 200

Generate a satterplot for enrollment data for top USA

See attached file. Consider the enrollment data for Business Week's top U.S. graduate business programs in the file P02_03.xlsx. Generate scatterplots to assess whether there is a systematic relationship between the total number of full-time students and each of the following: (a) the proportion of female students,

Forecast and Accuracy Measures

Treat each day of week as a different time series. For example, since this flight departs seven days per week, create seven forecasts. Sort the data by day of week and date. Then create scatter plots or line plots of each time series. From the plots, determine what the components of each time series are. Next, using the MSE

Scatter Independent Diagram

See attached file. Use the instructions on the first tab to complete. Use Literacy as the Independent variable (x) and Life Expenctancy as the Dependent variables (y) Use a scatterplot - may use Chart or MegaStat Scatterplot Chart: Select both columns of data Insert Chart - pick (x,y) sc

Statistics

Scatterplots show ________linear relationship.

IBM European Call Option Price

Assistance needed in Word. Day IBM Stock Price IBM European Call Option Price IBM European Put Option Price DESCRIPTION OF DATA 1 122.69 0 3.19 Column A represents the Time, in days. There are 30 days. 2 120.36 0 5.22 Column B is the IBM Stock Prices during 30 days 3 120.11 0 5.35 Column C is the IBM Call Option Prices d

Statistics 13-5, 13-9: Construct two scatter plots

13.5 Circulation is the lifeblood of the publishing business. The larger the sales of a magazine, the more it can charge advertisers. Recently, a circulation gap has appeared between the publishers reports of magazines newsstand sales and subsequent audits by the Audit Bureau of Circulations. The data below represent the reporte

Statistics: Reasoning Problems and Excel Scatter plots (See attachment).

Topic 2, Problem 5 - The following table gives information from a sample of college students: gender, number of children in family of origin, and number of children in their ideal family, in which they may someday be a parent ... Topic 2, Problem 6 - The following table of data gives hockey star Eric Lindros' career numbers

Constructing Scatter Plots

Below are four bivariate data sets ans the scatter plot for each is not included. Each data set is made up of sample values drawn from a population. Figure 1 Figure 2 Figure 3 Figure 4 x / y u / v w / t m / n 1.0 7.5 1.0 10.0 1.0 7.5

Scatter Plot Trendline Regression

(a) Use Excel to make a scatter plot of the data. (b) Select the data points, right-click, select Add Trendline, select the Options tab, and choose Display equation on chart and Display R-squared value on chart.(c) Interpret the fitted slope. (d) Is the intercept meaningful? Explain. (e) Interpret the R2. 12.18 Portfolio Retu

scatter plot and correlation

Given scatter plots: determine correlation among variables. Answer the following questions about the relationships between pairs of variables and the values of r, the sample correlation coefficient. The same response may be correct anser for more than one question. 1. For which data set is the sample correlation coefficient

Statistics: Scatterplot and Trendline

You are in charge of your company's complaint department. You want to see if the complaints are rising or falling, so you plot the number of complaints over the last 50 days that the company has been open for business. 1. Plot out the data using a scatterplot. What does this tell you? 2. Calculate a regression equati

Plot scattergrams for the following situations

Plot scattergrams for the following situations: a. A perfect positive correlation (r = +1.00) b. Positive correlation (r = +0.80) c. Negative correlation (r = -0.40) d. Absence of correlation (r = 0.00)

Quantitative analysis of a real estate business problem

Define and analyze a business problem within your company/industry or pretend company/industry with which you are familiar and for which you can provide a solution using quantitative methods.Because many actual business problems are more complex than others feel free to simplify your business problem, if necessary. Here is what

Scatter Diagram in Excel

Using excel, develop a scatter diagram for the following sample data. How would you describe the relationship between the values? X- Value 10, 8, 9, 11, 13, 11, 10, 7,7, 11 Y-Value 6, 2, 6, 5,7,6, 5, 2, 3, 7

Interpreting scatter plot data

I am trying to understand how the regression line "fits" into the scatter plot and how to extract and interpret the data being requested. Statistical Problem 1. The following scatterplot shows the miles per gallon for SUVs based on the horsepower of the engines. a. Draw the least squares regression line (a

Scatterplots, regression, and correlation

[See the attached file for Baldor Electric Co. Information.] a. Plot the variables Net Sales (y) and Working Capital (x) in scatter-plot format. What type of relationship appears to exist between Working Capital and Net Sales? Indicate whether a regression model or a correlation model would be more appropriate. Give statis

How much does Advertising Impact Market Penetration?

How much does advertising impact market penetration? To assess the impact of advertising in the tobacco industry, a study looked at the amount of money spent on advertising a particular brand of cigarettes and brand preference among adolescents and adults. The data are shown below: (Source: Center for Disease Control Website)

Scatterplot, Least Squares Regression & Score Prediction

The following table shows SAT scores (on the old SAT with only two sections) for a sample of students. Math 550 510 300 490 600 570 710 500 570 520 590 470 Verbal 560 490 720 500 590 550 410 510 580 520 490 480 a. Give the equation of the least squares regression equation. b. Make a scatterplot, and graph the LSRL on th

Scatter graph

I need help plotting a scatter graph in excel. How do you type it in to get a graph? For example if my Y , X 72 2 99 3 65 1 How do I plot this in excel to get a scatter graph?

Excel scatter plot diagram

Given the following data, 1) how do you make Excel create a scatter diagram for you? 2) If you were to draw a line through the points, how straight would the line be? 3) What is the coefficient of determination - r2 for this data, and more importantly, 4) what does it mean? # Employees # Orders received 1 1