MATLAB: An Introduction with Applications
6th Edition
ISBN: 9781119256830
Author: Amos Gilat
Publisher: John Wiley & Sons Inc
expand_more
expand_more
format_list_bulleted
Topic Video
Question
PLEASE HELP show me how to do this in excel.
The following observations are for two quantitative variables, x and y.
Observation | x | y |
---|---|---|
1 | 31 | 26 |
2 | 80 | 21 |
3 | 10 | 81 |
4 | 17 | 80 |
5 | 35 | 71 |
6 | 20 | 60 |
7 | 28 | 82 |
8 | 67 | 23 |
9 | 47 | 62 |
10 | 57 | 58 |
Observation | x | y |
---|---|---|
11 | 78 | 34 |
12 | 67 | 41 |
13 | 39 | 35 |
14 | 37 | 60 |
15 | 87 | 23 |
16 | 64 | 40 |
17 | 51 | 30 |
18 | 43 | 65 |
19 | 89 | 24 |
20 | 18 | 88 |
(a)
Develop a crosstabulation for the data, with x as the row variable and y as the column variable. For x use classes of 10–29, 30–49, and so on; for y use classes of 20–39, 40–59, and so on.
y | Grand Total | |||||
---|---|---|---|---|---|---|
20-39 | 40–59 | 60–79 | 80–99 | |||
10-29 | ||||||
30–49 | ||||||
X | 50–69 | |||||
70–90 | ||||||
Grand Total |
(b)
Compute the row percentages. (Round your answers to one decimal place.)
y | Grand Total | |||||
---|---|---|---|---|---|---|
20-39 | 40–59 | 60–79 | 80–99 | |||
10-29 | ||||||
30–49 | ||||||
X | 50–69 | |||||
70–90 | ||||||
Grand Total |
(c)
Compute the column percentages. (Round your answers to one decimal place.)
y | Grand Total | ||||||||
---|---|---|---|---|---|---|---|---|---|
20-39 | 40–59 | 60–79 | 80–99 | ||||||
10-29 | |||||||||
30–49 | |||||||||
X | 50–69 | ||||||||
70–90 | |||||||||
Grand Total |
(d)
What is the relationship, if any, between x and y?
Higher values of x are associated with ---Select--- higher values of y lower values of y . Lower values of x are associated with ---Select--- higher values of y lower values of y .
Expert Solution
This question has been solved!
Explore an expertly crafted, step-by-step solution for a thorough understanding of key concepts.
This is a popular solution
Trending nowThis is a popular solution!
Step by stepSolved in 3 steps with 6 images
Knowledge Booster
Learn more about
Need a deep-dive on the concept behind this application? Look no further. Learn more about this topic, statistics and related others by exploring similar questions and additional content below.Similar questions
- The following data was collected to explore how the average number of hours a student studies per night and the student's GPA affect their ACT score. The dependent variable is the ACT score, the first independent variable (x1) is the number of hours spent studying, and the second independent variable (x2) is the student's GPA. Effects on ACT Scores Study Hours GPA ACT Score 0 2 17 1 2 20 3 2 25 5 4 26 5 4 26 Copy Data Step 2 of 2: Determine if a statistically significant linear relationship exists between the independent and dependent variables at the 0.05 level of significance. If the relationship is statistically significant, identify the multiple regression equation that best fits the data, rounding the answers to three decimal places. Otherwise, indicate that there is not enough evidence to show that the relationship is statistically significant. Answer How to enter your answer (opens in new window) 2 Points Keypad Keyboard Shortcuts Selecting a checkbox will replace the entered…arrow_forwardUse the following data for questions 36 thru 38 below: Hint (Calculate the missing values using the formula for determining error. ) Period 1 2 3 4 5 6 Actual Demand 445 420 435 450 Forecast 420 450 440 450 430 Error 25 10 -30 20 Absolute Value of Error What is the mean forecast error (MFE) or bias for the six months of data? Absolute Percentage Errorarrow_forward5 and 6. The following data was collected from 1 bag of Hershey Kisses®. Each Kiss® was weighed in grams with the wrapper and recorded in the table below. Hershey claims that there are 368 grams of chocolate in one bag. Hershey Kiss Weights in Grams 4.76 4.72 4.74 4.55 4.91 4.74 4.78 4.71 4.80 4.78 4.78 4.75 4.79 4.82 4.91 4.83 4.68 4.74 4.70 4.80 4.70 4.76 4.70 4.83 4.93 4.74 4.84 4.82 4.76 4.77 4.72 4.78 4.83 4.75 4.74 4.68 4.84 4.71 4.71 4.76 4.66 4.78 4.73 4.74 4.92 4.77 4.80 4.79 4.86 4.64 4.78 4.70 4.75 4.78 4.76 4.83 4.66 4.77 4.83 4.78 4.69 4.81 4.68 4.78 4.88 4.72 4.85 4.85 4.81 4.74 4.80 4.82 4.84 4.70 4.85 4.70 4.81 4.72 4.79 4.73 4.61 Based on Hershey's® claim for 368 total net grams of chocolate in the bag, approximately how many Kisses® too many or too few are there? Assume that the Kisses® were weighed with the wrapper, each wrapper weighs 0.12 grams, and the net grams listed on the bag are for the chocolate only. Give some possible…arrow_forward
- IS YOUR DATA BASELINE DATA AUTOCORRELATED. behavior 2 4 6 8 10 o D 2 4 A time ° 6 8 0arrow_forwardThe following data was collected to explore how the average number of hours a student studies per night and the student's GPA affect their ACT score. The dependent variable is the ACT score, the first independent variable (x1�1) is the number of hours spent studying, and the second independent variable (x2�2) is the student's GPA. Effects on ACT Scores Study Hours GPA ACT Score 11 22 1818 55 22 2727 55 33 2929 66 33 3131 66 33 3131 Copy Data Step 1 of 2 : Find the p-value for the regression equation that fits the given data. Round your answer to four decimal placesarrow_forwardPLEASE ASSIST IN THIS PROBLEM- IT HAS NOT BEEN GRADED, THE RED X'S APPEAR WHEN I SELECT CHECK MY WORK.arrow_forward
- Which of the following statements is true? 1. The R (ie., R-squared) tells us the percentage of the variation in the dependent variable (cost) that is explained by variation in the independent variable (activity) II The R (e. R-squared) varies from 0% to 100%, and the lower the percentage, the better the fit of the data to a straight line. ONeither statement is true. Only statement I is true. Only statement II is tru. Both statements are true.arrow_forwardPlease answer this question below correctly.the scatterplot and answer choices is below. Question: What is the most reasonable value of y when x = 15?arrow_forwardThe table below shows the number of state-registered automatic weapons and the murder rate for several Northwestern states. xx 11.8 8.4 7.2 3.6 2.7 2.7 2.2 0.7 yy 13.8 11.5 10 7.2 6.4 6.1 6.2 4.4 xx = thousands of automatic weaponsyy = murders per 100,000 residents This data can be modeled by the equation y=0.84x+4.06.y=0.84x+4.06. Use this equation to answer the following;A) How many murders per 100,000 residents can be expected in a state with 2.7 thousand automatic weapons?Answer = Round to 3 decimal places.B) How many murders per 100,000 residents can be expected in a state with 4.9 thousand automatic weapons?Answer = Round to 3 decimal places.arrow_forward
- The following data was collected to explore how the average number of hours a student studies per night and the student's GPA affect their ACT score. The dependent variable is the ACT score, the first independent variable (x1�1) is the number of hours spent studying, and the second independent variable (x2�2) is the student's GPA. Effects on ACT Scores Study Hours GPA ACT Score 55 44 3030 44 33 3030 33 33 1919 33 33 1818 22 22 1818 Copy Data Step 1 of 2 : Find the p-value for the regression equation that fits the given data. Round your answer to four decimal placesarrow_forwardThe following statement contains an error. Choose the statement that best explains the error. "The correlation between shoe size and height is 0.87 inches" A. Correlation requires that both of the variables be categorical B. When stating the correlation coefficient, one must state whether it is a positive or negative relationship C. This statement does not tell us whether or not shoe size is correlated with height D. When reporting correlation, one does not report units because correlation has no units E. There is no error in this statementarrow_forwardPlease answer this question CORRECTLY!arrow_forward
arrow_back_ios
SEE MORE QUESTIONS
arrow_forward_ios
Recommended textbooks for you
- MATLAB: An Introduction with ApplicationsStatisticsISBN:9781119256830Author:Amos GilatPublisher:John Wiley & Sons IncProbability and Statistics for Engineering and th...StatisticsISBN:9781305251809Author:Jay L. DevorePublisher:Cengage LearningStatistics for The Behavioral Sciences (MindTap C...StatisticsISBN:9781305504912Author:Frederick J Gravetter, Larry B. WallnauPublisher:Cengage Learning
- Elementary Statistics: Picturing the World (7th E...StatisticsISBN:9780134683416Author:Ron Larson, Betsy FarberPublisher:PEARSONThe Basic Practice of StatisticsStatisticsISBN:9781319042578Author:David S. Moore, William I. Notz, Michael A. FlignerPublisher:W. H. FreemanIntroduction to the Practice of StatisticsStatisticsISBN:9781319013387Author:David S. Moore, George P. McCabe, Bruce A. CraigPublisher:W. H. Freeman
MATLAB: An Introduction with Applications
Statistics
ISBN:9781119256830
Author:Amos Gilat
Publisher:John Wiley & Sons Inc
Probability and Statistics for Engineering and th...
Statistics
ISBN:9781305251809
Author:Jay L. Devore
Publisher:Cengage Learning
Statistics for The Behavioral Sciences (MindTap C...
Statistics
ISBN:9781305504912
Author:Frederick J Gravetter, Larry B. Wallnau
Publisher:Cengage Learning
Elementary Statistics: Picturing the World (7th E...
Statistics
ISBN:9780134683416
Author:Ron Larson, Betsy Farber
Publisher:PEARSON
The Basic Practice of Statistics
Statistics
ISBN:9781319042578
Author:David S. Moore, William I. Notz, Michael A. Fligner
Publisher:W. H. Freeman
Introduction to the Practice of Statistics
Statistics
ISBN:9781319013387
Author:David S. Moore, George P. McCabe, Bruce A. Craig
Publisher:W. H. Freeman