HW#3b F21-1

xlsx

School

Arizona State University *

*We aren’t endorsed by this school

Course

300

Subject

Statistics

Date

Jun 1, 2024

Type

xlsx

Pages

47

Uploaded by MegaGoldfishPerson1124

Report
UNHEALTH Description & Instructions: 0 0 0 0 1 0 0 30 4 0 0 30 7 0 0 2 999 0 0 0 0 0 0 Bin Frequency 0 10 411 10 20 25 999 30 47 0 More 17 0 30 30 0 1 20 0 2 2 0 10 30 0 0 0 0 0 10 20 30 More 0 50 100 150 200 250 300 350 400 450 Number of Unhealthy People Days Number of People
30 1 2 3 0 0 5 3 0 6 0 30 2 1 30 5 3 0 0 20 0 0 0 10 0 0 3 0 0 0 999 3 0 0 0 0 30 0 1 0 999 0 30 5 0
0 17 0 0 0 0 0 3 0 0 10 0 4 0 15 0 2 0 0 30 0 30 3 0 0 14 2 0 0 0 5 0 2 30 0 25 0 0 3 0 0 30 11 30 30
Your preview ends here
Eager to read complete document? Join bartleby learn and gain access to the full version
  • Access to all documents
  • Unlimited textbook solutions
  • 24/7 expert homework help
0 999 0 0 5 2 11 0 18 0 4 0 0 0 0 2 15 8 0 0 0 30 4 0 0 7 0 0 3 2 30 999 0 0 13 0 0 0 2 0 0 0 0 5 7
0 0 1 0 6 5 2 15 30 15 30 2 0 1 0 7 9 0 1 5 2 5 0 30 3 3 3 0 2 2 0 30 0 0 999 1 0 0 0 10 0 1 0 1 5
0 0 8 0 0 0 0 0 0 0 1 999 0 7 0 0 5 999 2 30 0 4 2 0 0 0 3 0 10 5 0 2 0 2 999 0 6 2 30 0 0 2 4 0 0
Your preview ends here
Eager to read complete document? Join bartleby learn and gain access to the full version
  • Access to all documents
  • Unlimited textbook solutions
  • 24/7 expert homework help
15 3 0 30 0 0 2 4 0 5 30 5 16 30 0 0 0 0 4 0 30 0 2 999 0 1 2 2 10 1 8 3 7 0 0 2 0 0 0 15 20 0 0 0 6
0 1 0 0 0 30 5 0 0 0 20 8 0 1 2 2 13 0 30 30 0 0 30 4 4 0 7 2 0 1 999 999 3 0 0 2 15 1 4 6 999 0 0 0 0
0 0 1 5 0 0 0 999 3 4 2 1 0 0 3 2 3 0 30 0 0 0 0 30 15 2 0 30 0 8 3 2 7 0 1 0 5 4 3 0 30 0 0 3 0
Your preview ends here
Eager to read complete document? Join bartleby learn and gain access to the full version
  • Access to all documents
  • Unlimited textbook solutions
  • 24/7 expert homework help
0 0 3 7 9 2 30 0 0 14 0 24 0 0 24 0 0 0 0 0 20 0 21 4 30 0 0 8 3 0 0 0 5 0 9 0 0 0 2 3 1 0 0 0 30
30 14 2 2 0 5 30 2 0 17 0 0 5 30 2 0 30 4 0 0 0 0 2 0 5 0 0 0 0 0 1 0 999 0 3 0 999 2 0 0 3 0 3 0 7
3 0 15 10 3 0
Your preview ends here
Eager to read complete document? Join bartleby learn and gain access to the full version
  • Access to all documents
  • Unlimited textbook solutions
  • 24/7 expert homework help
The data in column A are from the Behavioral Risk Factor Surveillance System. A sample of 500 people in Seattle were surveyed via phone. The variable "UNHEALTH" is defined as: the sum of physically and mentally unhealthy days reported during the past month. Values range from 0-30. 999 indicates a missing value. Create a histogram which meaningfully and accurately displays the data. Ensure you represent all the data. (HINT: use the histogram data analysis tool in the data analysis toolpak). Ensure a good title and accurate axes labels.
gender pre.weight post.weight Description and instructions: 0 58 54.2 0 60 54 0 64 63.3 0 64 61.1 0 65 62.2 0 66 64 0 67 65 0 69 60.5 0 70 68.1 0 70 66.9 0 72 70.5 0 72 69 0 72 68.4 0 82 81.1 0 58 60.1 0 58 56 0 59 57.3 0 61 56.7 0 62 55 0 63 62.4 0 63 60.3 0 63 59.4 0 65 62 0 66 64 0 68 63.8 0 68 63.3 0 76 72.7 0 77 77.5 0 60 53 0 62 56.4 0 64 60.6 0 65 58.2 0 66 58.2 0 67 61.6 0 67 60.2 0 69 61.8 0 70 63 0 70 62.7 0 72 71.1 0 72 64.4 0 73 68.9 0 75 68.7 0 76 71 1 60 60 Average Weight Pre/Po
1 103 103 1 71 71.6 1 72 70.9 1 74 69.5 1 78 73.9 1 80 71 1 80 77.6 1 83 79.1 1 85 81.5 1 87 81.9 1 88 84.5 1 71 66.8 1 75 72.6 1 75 69.2 1 76 72.5 1 78 72.7 Pre-Weight Post-Weight 1 78 76.3 Women 67.11627906977 63.2232558 1 79 73.6 Men 79.17142857143 75.3857143 1 79 72.9 1 79 71.1 1 80 81.4 1 80 75.7 1 71 68.5 1 73 72.1 1 76 72.5 1 78 77.5 1 78 75.2 1 78 69.4 1 79 74.5 1 83 80.2 1 84 79.9 1 85 79.7 1 87 77.8 1 88 81.9 Pre-Weight 50 55 60 65 70 75 80 85 90 Average Weight Pre/Po Women Men KG
Your preview ends here
Eager to read complete document? Join bartleby learn and gain access to the full version
  • Access to all documents
  • Unlimited textbook solutions
  • 24/7 expert homework help
Data show weights in kg of a sample of men (1) & female (0) before and after a diet intervention. Display the AVERAGE weights of the men and women at the beginning and end of the intervention using a line chart. (hint: you have to create a 2x2 table using the data provided - using good labels when creating the table will help when you insert the line chart). Please ensure you have a good title and axes labels in the chart. ost Diet
Post-Weight ost Diet n
apply Description & Instructions: 3 2 1 2 2 1 2 2 1 2 1 Categories 2 Unlikely 1 3 Somewhat 2 2 Very Likely 3 1 Total 1 1 1 3 2 3 2 1 1 1 2 2 2 3 1 2 1 1 1 1 1 1 2 2 1 1 Data shows asked stude scale is cod chart show (Hint: creat provide a g 35% 10% College Gra
Your preview ends here
Eager to read complete document? Join bartleby learn and gain access to the full version
  • Access to all documents
  • Unlimited textbook solutions
  • 24/7 expert homework help
2 1 2 2 1 1 1 1 2 1 1 3 1 2 2 2 1 1 1 2 1 1 1 3 2 1 1 1 1 1 1 1 3 1 1 1 3 2 1 1 1 1
1 1 3 1 1 2 2 3 2 1 3 1 3 2 1 2 2 1 1 1 2 2 2 2 2 2 2 2 1 1 2 2 1 1 1 1 1 2 1 1 1 2
2 2 1 1 1 1 1 1 2 2 2 1 3 1 1 1 1 1 1 3 1 1 1 1 1 3 2 2 2 1 1 1 2 2 1 2 2 2 1 1 1 1
Your preview ends here
Eager to read complete document? Join bartleby learn and gain access to the full version
  • Access to all documents
  • Unlimited textbook solutions
  • 24/7 expert homework help
1 1 1 1 1 2 1 2 3 1 2 2 3 1 2 2 3 3 3 1 1 2 1 2 1 2 1 2 2 2 1 1 1 1 1 2 3 1 1 3 2 1
Your preview ends here
Eager to read complete document? Join bartleby learn and gain access to the full version
  • Access to all documents
  • Unlimited textbook solutions
  • 24/7 expert homework help
1 3 1 1 3 2 1 1 1 2 2 2 2 1 2 1 1 3 2 1 1 1 2 2 1 1 1 1 2 2 1 1 2 2 1 1 3 2 2 1 1 2
Your preview ends here
Eager to read complete document? Join bartleby learn and gain access to the full version
  • Access to all documents
  • Unlimited textbook solutions
  • 24/7 expert homework help
2 2 2 2 1 1 3 1 2 2 2 1 1 1 1 2 3 1 1 2 1 1 1 3 2 2 1 2 1 1 1 2 1 1 2 1 2 1 1 1 2 2
Your preview ends here
Eager to read complete document? Join bartleby learn and gain access to the full version
  • Access to all documents
  • Unlimited textbook solutions
  • 24/7 expert homework help
2 1 1 2 2 3 1 1 2 1 1 2 1 1 2 1 1 1 1 1 3 1 2 2 2 1 2 1 1 1 1 1 1 2 1 2 1 2 1 2 1 1
Your preview ends here
Eager to read complete document? Join bartleby learn and gain access to the full version
  • Access to all documents
  • Unlimited textbook solutions
  • 24/7 expert homework help
1 1 1 1 1 1 1 2 1 3 2 2 3 3 1 2 2 2 1 1 1 2 1 3 2 1 2 3 1 1 2 2 1 1 1 1 1 1 1 1 1 2
Your preview ends here
Eager to read complete document? Join bartleby learn and gain access to the full version
  • Access to all documents
  • Unlimited textbook solutions
  • 24/7 expert homework help
2 1 1 1 2 1 2 2 1 2 3 1 1 1 2 3 2 2 1 1 2 2 3
Your preview ends here
Eager to read complete document? Join bartleby learn and gain access to the full version
  • Access to all documents
  • Unlimited textbook solutions
  • 24/7 expert homework help
Frequency 220 140 40 400 s responses from a sample of 400 college juniors. The question ents how likely they are to apply to graduate school. The ordinal ded 1=unlikely, 2=somewhat likely, 3=very likely. Create a pie wing the frequency as a percent of the total for each response. te a frequency distribution table first). Please ensure that you good title for the chart as well as the key. 55% aduate Applicants Unlikely Somewhat Likely Very Likely
Your preview ends here
Eager to read complete document? Join bartleby learn and gain access to the full version
  • Access to all documents
  • Unlimited textbook solutions
  • 24/7 expert homework help
apply Description & instructions: 3 2 1 2 2 1 2 2 1 2 1 2 3 2 Categories Frequency 1 Unlikely 1 220 1 Somewhat 2 140 1 Very Likely 3 40 1 Total 400 3 2 3 2 1 1 1 2 2 2 3 1 2 1 1 1 1 1 1 2 2 1 1 These data distribution data in a ba axis labels. Somewh Ve
Your preview ends here
Eager to read complete document? Join bartleby learn and gain access to the full version
  • Access to all documents
  • Unlimited textbook solutions
  • 24/7 expert homework help
2 1 2 2 1 1 1 1 2 1 1 3 1 2 2 2 1 1 1 2 1 1 1 3 2 1 1 1 1 1 1 1 3 1 1 1 3 2 1 1 1 1
Your preview ends here
Eager to read complete document? Join bartleby learn and gain access to the full version
  • Access to all documents
  • Unlimited textbook solutions
  • 24/7 expert homework help
1 1 3 1 1 2 2 3 2 1 3 1 3 2 1 2 2 1 1 1 2 2 2 2 2 2 2 2 1 1 2 2 1 1 1 1 1 2 1 1 1 2
Your preview ends here
Eager to read complete document? Join bartleby learn and gain access to the full version
  • Access to all documents
  • Unlimited textbook solutions
  • 24/7 expert homework help
2 2 1 1 1 1 1 1 2 2 2 1 3 1 1 1 1 1 1 3 1 1 1 1 1 3 2 2 2 1 1 1 2 2 1 2 2 2 1 1 1 1
Your preview ends here
Eager to read complete document? Join bartleby learn and gain access to the full version
  • Access to all documents
  • Unlimited textbook solutions
  • 24/7 expert homework help
1 1 1 1 1 2 1 2 3 1 2 2 3 1 2 2 3 3 3 1 1 2 1 2 1 2 1 2 2 2 1 1 1 1 1 2 3 1 1 3 2 1
Your preview ends here
Eager to read complete document? Join bartleby learn and gain access to the full version
  • Access to all documents
  • Unlimited textbook solutions
  • 24/7 expert homework help
1 3 1 1 3 2 1 1 1 2 2 2 2 1 2 1 1 3 2 1 1 1 2 2 1 1 1 1 2 2 1 1 2 2 1 1 3 2 2 1 1 2
Your preview ends here
Eager to read complete document? Join bartleby learn and gain access to the full version
  • Access to all documents
  • Unlimited textbook solutions
  • 24/7 expert homework help
2 2 2 2 1 1 3 1 2 2 2 1 1 1 1 2 3 1 1 2 1 1 1 3 2 2 1 2 1 1 1 2 1 1 2 1 2 1 1 1 2 2
Your preview ends here
Eager to read complete document? Join bartleby learn and gain access to the full version
  • Access to all documents
  • Unlimited textbook solutions
  • 24/7 expert homework help
2 1 1 2 2 3 1 1 2 1 1 2 1 1 2 1 1 1 1 1 3 1 2 2 2 1 2 1 1 1 1 1 1 2 1 2 1 2 1 2 1 1
Your preview ends here
Eager to read complete document? Join bartleby learn and gain access to the full version
  • Access to all documents
  • Unlimited textbook solutions
  • 24/7 expert homework help
1 1 1 1 1 1 1 2 1 3 2 2 3 3 1 2 2 2 1 1 1 2 1 3 2 1 2 3 1 1 2 2 1 1 1 1 1 1 1 1 1 2
Your preview ends here
Eager to read complete document? Join bartleby learn and gain access to the full version
  • Access to all documents
  • Unlimited textbook solutions
  • 24/7 expert homework help
2 1 1 1 2 1 2 2 1 2 3 1 1 1 2 3 2 2 1 1 2 2 3
Your preview ends here
Eager to read complete document? Join bartleby learn and gain access to the full version
  • Access to all documents
  • Unlimited textbook solutions
  • 24/7 expert homework help
a are the same as in question #3 - using the frequency n table you have already created, display the ordinal ar chart. Be sure to include an appropriate title and Unlikely hat Likely ery Likely 0 50 100 150 200 250 220 140 40 College Graduate Applicants College Juniors
Your preview ends here
Eager to read complete document? Join bartleby learn and gain access to the full version
  • Access to all documents
  • Unlimited textbook solutions
  • 24/7 expert homework help
Patients Who Participated Age Fructosamine Weight Age Fructosamine Weight Levels Levels 16 210 160 41 210 172 45 144 144 30 174 151 56 200 138 65 205 143 31 156 168 61 176 182 22 208 129 47 258 130 19 173 150 82 175 202 51 197 171 74 202 202 48 182 158 56 192 126 36 210 183 88 215 190 65 184 183 31 188 139 59 166 125 23 173 199 44 159 174 58 152 159 70 193 136 71 183 187 23 148 181 46 220 169 Did Participate Did Not Participate 210 210 144 174 200 205 156 176 208 258 173 175 197 202 182 192 210 215 184 188 166 173 159 152 193 183 Patients Who Did Not Participate
Your preview ends here
Eager to read complete document? Join bartleby learn and gain access to the full version
  • Access to all documents
  • Unlimited textbook solutions
  • 24/7 expert homework help
148 220
Your preview ends here
Eager to read complete document? Join bartleby learn and gain access to the full version
  • Access to all documents
  • Unlimited textbook solutions
  • 24/7 expert homework help
Description: The following data shows fructosamine levels for patients who par manage their diabetes. The program involved group meetings and expert health coaches. The age and weight of participants in the p to display the fructosamine levels for patients who participated in who did not participate in the program. Do not include other infor submissions. Ensure both box plots are on the same chart. This chart isn't available in your version of Excel. Editing this shape or saving this workbook into a different file format will permanently break the chart.
Your preview ends here
Eager to read complete document? Join bartleby learn and gain access to the full version
  • Access to all documents
  • Unlimited textbook solutions
  • 24/7 expert homework help
rticipated in a program to d individualized attention from program varied. Create boxplots n the program and for patients rmation or data in your
Your preview ends here
Eager to read complete document? Join bartleby learn and gain access to the full version
  • Access to all documents
  • Unlimited textbook solutions
  • 24/7 expert homework help
Patients Who Participated Age Fructosamine Weight Age Fructosamine Weight Levels Levels 16 210 160 41 210 172 45 144 144 30 174 151 56 200 138 65 205 143 31 156 168 61 176 182 22 208 129 47 258 130 19 173 150 82 175 202 51 197 171 74 202 202 48 182 158 56 192 126 36 210 183 88 215 190 65 184 183 31 188 139 59 166 125 23 173 199 44 159 174 58 152 159 70 193 136 71 183 187 23 148 181 46 220 169 IF you are having trouble creating a box plot on the previous tab with your version of EXCEL, you Fill in the 5 number summary for each group, and the chart will autopop Fructosamine Levels Shared Visits No Shared Visits Min 144 152 Q1 160.75 175.25 Med 183 190 Q3 199.25 208.75 Max 210 258 Differences Shared Visits No Shared Visits Min 144 152 Q1-Min 16.75 23.25 Median-Q1 22.25 14.75 Q3-median 16.25 18.75 Max-Q3 10.75 49.25 Patients Who Did Not Participate Shared Visits No Shared Visits 0
Your preview ends here
Eager to read complete document? Join bartleby learn and gain access to the full version
  • Access to all documents
  • Unlimited textbook solutions
  • 24/7 expert homework help
Your preview ends here
Eager to read complete document? Join bartleby learn and gain access to the full version
  • Access to all documents
  • Unlimited textbook solutions
  • 24/7 expert homework help
Description: u can use this manual version (enter the 5-number summary below) pulate. You can then adjust chart formatting, such as titles. The following data shows fructosamine levels for patients who par manage their diabetes. The program involved group meetings and expert health coaches. The age and weight of participants in the p to display the fructosamine levels for patients who participated in who did not participate in the program. Do not include other infor submissions. Please improve the chart title 50 100 150 200 250 300 Fructosamine Levels
Your preview ends here
Eager to read complete document? Join bartleby learn and gain access to the full version
  • Access to all documents
  • Unlimited textbook solutions
  • 24/7 expert homework help
rticipated in a program to d individualized attention from program varied. Create boxplots n the program and for patients rmation or data in your
Your preview ends here
Eager to read complete document? Join bartleby learn and gain access to the full version
  • Access to all documents
  • Unlimited textbook solutions
  • 24/7 expert homework help