Use Excel to calculate the sample size for both years, confidence coefficient (95%) for both years, the margin of error for both years, and correlation coefficient for both years. County Average Income Year County Average Income Year Adams $42,944 2014 Adams $51,500 2018 Allen $48,795 2014 Allen $51,300 2018 Bartholomew $53,475 2014 Bartholomew $59,800 2018 Benton $48,692 2014 Benton $47,200 2018 Blackford $38,927 2014 Blackford $42,600 2018 Boone $69,919 2014 Boone $80,600 2018 Brown $49,837 2014 Brown $56,300 2018 Carroll $51,038 2014 Carroll $55,700 2018 Cass $40,809 2014 Cass $46,300 2018 Clark $49,164 2014 Clark $51,800 2018 Clay $44,230 2014 Clay $50,200 2018 Clinton $47,748 2014 Clinton $53,900 2018 Crawford $39,534 2014 Crawford $46,200 2018 Daviess $44,689 2014 Daviess $49,200 2018 Dearborn $57,465 2014 Dearborn $63,900 2018 Decatur $47,387 2014 Decatur $52,000 2018 DeKalb $48,116 2014 DeKalb $52,600 2018 Delaware $37,339 2014 Delaware $41,400 2018 Dubois $53,814 2014 Dubois $62,900 2018 Elkhart $45,806 2014 Elkhart $54,600 2018 Fayette $39,998 2014 Fayette $44,700 2018 Floyd $53,367 2014 Floyd $58,700 2018 Fountain $47,905 2014 Fountain $43,600 2018 Franklin $45,992 2014 Franklin $57,700 2018 Fulton $44,300 2014 Fulton $46,700 2018 Gibson $49,320 2014 Gibson $54,700 2018 Grant $39,151 2014 Grant $40,200 2018 Greene $42,684 2014 Greene $46,000 2018 Hamilton $88,429 2014 Hamilton $92,400 2018 Hancock $66,131 2014 Hancock $70,700 2018 Harrison $50,704 2014 Harrison $57,600 2018 Hendricks $70,886 2014 Hendricks $78,500 2018 Henry $41,565 2014 Henry $45,400 2018 Howard $42,148 2014 Howard $49,200 2018 Huntington $43,552 2014 Huntington $50,100 2018 Jackson $46,573 2014 Jackson $51,900 2018 Jasper $54,092 2014 Jasper $56,000 2018 Jay $42,410 2014 Jay $46,900 2018 Jefferson $43,104 2014 Jefferson $51,500 2018 Jennings $46,023 2014 Jennings $50,400 2018 Johnson $61,671 2014 Johnson $67,200 2018 Knox $41,356 2014 Knox $43,900 2018 Kosciusko $50,153 2014 Kosciusko $56,000 2018 LaGrange $47,870 2014 LaGrange $60,400 2018 Lake $48,015 2014 Lake $53,600 2018 LaPorte $46,127 2014 LaPorte $52,800 2018 Lawrence $39,447 2014 Lawrence $48,000 2018 Madison $42,707 2014 Madison $45,900 2018 Marion $41,586 2014 Marion $45,300 2018 Marshall $46,129 2014 Marshall $53,800 2018 Martin $44,597 2014 Martin $51,000 2018 Miami $43,608 2014 Miami $47,700 2018 Monroe $39,309 2014 Monroe $44,400 2018 Montgomery $45,404 2014 Montgomery $51,500 2018 Morgan $52,886 2014 Morgan $60,500 2018 Newton $50,129 2014 Newton $51,200 2018 Noble $44,192 2014 Noble $52,300 2018 Ohio $49,301 2014 Ohio $54,400 2018 Orange $38,651 2014 Orange $41,100 2018 Owen $41,106 2014 Owen $46,100 2018 Parke $41,311 2014 Parke $47,600 2018 Perry $42,942 2014 Perry $48,900 2018 Pike $44,977 2014 Pike $49,600 2018 Porter $63,879 2014 Porter $67,300 2018 Posey $61,587 2014 Posey $61,600 2018 Pulaski $41,818 2014 Pulaski $47,200 2018 Putnam $47,161 2014 Putnam $50,900 2018 Randolph $40,656 2014 Randolph $46,800 2018 Ripley $48,227 2014 Ripley $55,100 2018 Rush $44,979 2014 Rush $50,400 2018 Scott $40,299 2014 Scott $47,700 2018 Shelby $49,965 2014 Shelby $53,000 2018 Spencer $55,824 2014 Spencer $58,200 2018 St. Joseph $45,248 2014 St. Joseph $49,000 2018 Starke $41,700 2014 Starke $46,600 2018 Steuben $46,412 2014 Steuben $54,100 2018 Sullivan $41,223 2014 Sullivan $46,700 2018 Switzerland $42,497 2014 Switzerland $45,300 2018 Tippecanoe $43,529 2014 Tippecanoe $51,400 2018 Tipton $53,917 2014 Tipton $60,800 2018 Union $44,796 2014 Union $46,900 2018 Vanderburgh $41,784 2014 Vanderburgh $46,800 2018 Vermillion $42,709 2014 Vermillion $51,400 2018 Vigo $40,091 2014 Vigo $43,600 2018 Wabash $45,849 2014 Wabash $51,600 2018 Warren $53,781 2014 Warren $55,500 2018 Warrick $60,551 2014 Warrick $65,800 2018 Washington $41,598 2014 Washington $48,900 2018 Wayne $35,220 2014 Wayne $43,000 2018 Wells $49,264 2014 Wells $56,100 2018 White $48,274 2014 White $47,400 2018 Whitley $52,081 2014 Whitley $54,900 2018

Use Excel to calculate the sample size for both years, confidence coefficient (95%) for both years, the margin of error for both years, and correlation coefficient for both years. County Average Income Year County Average Income Year Adams $42,944 2014 Adams $51,500 2018 Allen $48,795 2014 Allen $51,300 2018 Bartholomew $53,475 2014 Bartholomew $59,800 2018 Benton $48,692 2014 Benton $47,200 2018 Blackford $38,927 2014 Blackford $42,600 2018 Boone $69,919 2014 Boone $80,600 2018 Brown $49,837 2014 Brown $56,300 2018 Carroll $51,038 2014 Carroll $55,700 2018 Cass $40,809 2014 Cass $46,300 2018 Clark $49,164 2014 Clark $51,800 2018 Clay $44,230 2014 Clay $50,200 2018 Clinton $47,748 2014 Clinton $53,900 2018 Crawford $39,534 2014 Crawford $46,200 2018 Daviess $44,689 2014 Daviess $49,200 2018 Dearborn $57,465 2014 Dearborn $63,900 2018 Decatur $47,387 2014 Decatur $52,000 2018 DeKalb $48,116 2014 DeKalb $52,600 2018 Delaware $37,339 2014 Delaware $41,400 2018 Dubois $53,814 2014 Dubois $62,900 2018 Elkhart $45,806 2014 Elkhart $54,600 2018 Fayette $39,998 2014 Fayette $44,700 2018 Floyd $53,367 2014 Floyd $58,700 2018 Fountain $47,905 2014 Fountain $43,600 2018 Franklin $45,992 2014 Franklin $57,700 2018 Fulton $44,300 2014 Fulton $46,700 2018 Gibson $49,320 2014 Gibson $54,700 2018 Grant $39,151 2014 Grant $40,200 2018 Greene $42,684 2014 Greene $46,000 2018 Hamilton $88,429 2014 Hamilton $92,400 2018 Hancock $66,131 2014 Hancock $70,700 2018 Harrison $50,704 2014 Harrison $57,600 2018 Hendricks $70,886 2014 Hendricks $78,500 2018 Henry $41,565 2014 Henry $45,400 2018 Howard $42,148 2014 Howard $49,200 2018 Huntington $43,552 2014 Huntington $50,100 2018 Jackson $46,573 2014 Jackson $51,900 2018 Jasper $54,092 2014 Jasper $56,000 2018 Jay $42,410 2014 Jay $46,900 2018 Jefferson $43,104 2014 Jefferson $51,500 2018 Jennings $46,023 2014 Jennings $50,400 2018 Johnson $61,671 2014 Johnson $67,200 2018 Knox $41,356 2014 Knox $43,900 2018 Kosciusko $50,153 2014 Kosciusko $56,000 2018 LaGrange $47,870 2014 LaGrange $60,400 2018 Lake $48,015 2014 Lake $53,600 2018 LaPorte $46,127 2014 LaPorte $52,800 2018 Lawrence $39,447 2014 Lawrence $48,000 2018 Madison $42,707 2014 Madison $45,900 2018 Marion $41,586 2014 Marion $45,300 2018 Marshall $46,129 2014 Marshall $53,800 2018 Martin $44,597 2014 Martin $51,000 2018 Miami $43,608 2014 Miami $47,700 2018 Monroe $39,309 2014 Monroe $44,400 2018 Montgomery $45,404 2014 Montgomery $51,500 2018 Morgan $52,886 2014 Morgan $60,500 2018 Newton $50,129 2014 Newton $51,200 2018 Noble $44,192 2014 Noble $52,300 2018 Ohio $49,301 2014 Ohio $54,400 2018 Orange $38,651 2014 Orange $41,100 2018 Owen $41,106 2014 Owen $46,100 2018 Parke $41,311 2014 Parke $47,600 2018 Perry $42,942 2014 Perry $48,900 2018 Pike $44,977 2014 Pike $49,600 2018 Porter $63,879 2014 Porter $67,300 2018 Posey $61,587 2014 Posey $61,600 2018 Pulaski $41,818 2014 Pulaski $47,200 2018 Putnam $47,161 2014 Putnam $50,900 2018 Randolph $40,656 2014 Randolph $46,800 2018 Ripley $48,227 2014 Ripley $55,100 2018 Rush $44,979 2014 Rush $50,400 2018 Scott $40,299 2014 Scott $47,700 2018 Shelby $49,965 2014 Shelby $53,000 2018 Spencer $55,824 2014 Spencer $58,200 2018 St. Joseph $45,248 2014 St. Joseph $49,000 2018 Starke $41,700 2014 Starke $46,600 2018 Steuben $46,412 2014 Steuben $54,100 2018 Sullivan $41,223 2014 Sullivan $46,700 2018 Switzerland $42,497 2014 Switzerland $45,300 2018 Tippecanoe $43,529 2014 Tippecanoe $51,400 2018 Tipton $53,917 2014 Tipton $60,800 2018 Union $44,796 2014 Union $46,900 2018 Vanderburgh $41,784 2014 Vanderburgh $46,800 2018 Vermillion $42,709 2014 Vermillion $51,400 2018 Vigo $40,091 2014 Vigo $43,600 2018 Wabash $45,849 2014 Wabash $51,600 2018 Warren $53,781 2014 Warren $55,500 2018 Warrick $60,551 2014 Warrick $65,800 2018 Washington $41,598 2014 Washington $48,900 2018 Wayne $35,220 2014 Wayne $43,000 2018 Wells $49,264 2014 Wells $56,100 2018 White $48,274 2014 White $47,400 2018 Whitley $52,081 2014 Whitley $54,900 2018

Advanced Engineering Mathematics

10th Edition

ISBN:9780470458365

Author:Erwin Kreyszig

Publisher:Erwin Kreyszig

Chapter2: Second-order Linear Odes

Section: Chapter Questions

Problem 1RQ

See similar textbooks

Related questions

Concept explainers

Question

Use Excel to calculate the sample size for both years, confidence coefficient (95%) for both years, the margin of error for both years, and correlation coefficient for both years.

County	Average Income	Year	County	Average Income	Year
Adams	$42,944	2014	Adams	$51,500	2018
Allen	$48,795	2014	Allen	$51,300	2018
Bartholomew	$53,475	2014	Bartholomew	$59,800	2018
Benton	$48,692	2014	Benton	$47,200	2018
Blackford	$38,927	2014	Blackford	$42,600	2018
Boone	$69,919	2014	Boone	$80,600	2018
Brown	$49,837	2014	Brown	$56,300	2018
Carroll	$51,038	2014	Carroll	$55,700	2018
Cass	$40,809	2014	Cass	$46,300	2018
Clark	$49,164	2014	Clark	$51,800	2018
Clay	$44,230	2014	Clay	$50,200	2018
Clinton	$47,748	2014	Clinton	$53,900	2018
Crawford	$39,534	2014	Crawford	$46,200	2018
Daviess	$44,689	2014	Daviess	$49,200	2018
Dearborn	$57,465	2014	Dearborn	$63,900	2018
Decatur	$47,387	2014	Decatur	$52,000	2018
DeKalb	$48,116	2014	DeKalb	$52,600	2018
Delaware	$37,339	2014	Delaware	$41,400	2018
Dubois	$53,814	2014	Dubois	$62,900	2018
Elkhart	$45,806	2014	Elkhart	$54,600	2018
Fayette	$39,998	2014	Fayette	$44,700	2018
Floyd	$53,367	2014	Floyd	$58,700	2018
Fountain	$47,905	2014	Fountain	$43,600	2018
Franklin	$45,992	2014	Franklin	$57,700	2018
Fulton	$44,300	2014	Fulton	$46,700	2018
Gibson	$49,320	2014	Gibson	$54,700	2018
Grant	$39,151	2014	Grant	$40,200	2018
Greene	$42,684	2014	Greene	$46,000	2018
Hamilton	$88,429	2014	Hamilton	$92,400	2018
Hancock	$66,131	2014	Hancock	$70,700	2018
Harrison	$50,704	2014	Harrison	$57,600	2018
Hendricks	$70,886	2014	Hendricks	$78,500	2018
Henry	$41,565	2014	Henry	$45,400	2018
Howard	$42,148	2014	Howard	$49,200	2018
Huntington	$43,552	2014	Huntington	$50,100	2018
Jackson	$46,573	2014	Jackson	$51,900	2018
Jasper	$54,092	2014	Jasper	$56,000	2018
Jay	$42,410	2014	Jay	$46,900	2018
Jefferson	$43,104	2014	Jefferson	$51,500	2018
Jennings	$46,023	2014	Jennings	$50,400	2018
Johnson	$61,671	2014	Johnson	$67,200	2018
Knox	$41,356	2014	Knox	$43,900	2018
Kosciusko	$50,153	2014	Kosciusko	$56,000	2018
LaGrange	$47,870	2014	LaGrange	$60,400	2018
Lake	$48,015	2014	Lake	$53,600	2018
LaPorte	$46,127	2014	LaPorte	$52,800	2018
Lawrence	$39,447	2014	Lawrence	$48,000	2018
Madison	$42,707	2014	Madison	$45,900	2018
Marion	$41,586	2014	Marion	$45,300	2018
Marshall	$46,129	2014	Marshall	$53,800	2018
Martin	$44,597	2014	Martin	$51,000	2018
Miami	$43,608	2014	Miami	$47,700	2018
Monroe	$39,309	2014	Monroe	$44,400	2018
Montgomery	$45,404	2014	Montgomery	$51,500	2018
Morgan	$52,886	2014	Morgan	$60,500	2018
Newton	$50,129	2014	Newton	$51,200	2018
Noble	$44,192	2014	Noble	$52,300	2018
Ohio	$49,301	2014	Ohio	$54,400	2018
Orange	$38,651	2014	Orange	$41,100	2018
Owen	$41,106	2014	Owen	$46,100	2018
Parke	$41,311	2014	Parke	$47,600	2018
Perry	$42,942	2014	Perry	$48,900	2018
Pike	$44,977	2014	Pike	$49,600	2018
Porter	$63,879	2014	Porter	$67,300	2018
Posey	$61,587	2014	Posey	$61,600	2018
Pulaski	$41,818	2014	Pulaski	$47,200	2018
Putnam	$47,161	2014	Putnam	$50,900	2018
Randolph	$40,656	2014	Randolph	$46,800	2018
Ripley	$48,227	2014	Ripley	$55,100	2018
Rush	$44,979	2014	Rush	$50,400	2018
Scott	$40,299	2014	Scott	$47,700	2018
Shelby	$49,965	2014	Shelby	$53,000	2018
Spencer	$55,824	2014	Spencer	$58,200	2018
St. Joseph	$45,248	2014	St. Joseph	$49,000	2018
Starke	$41,700	2014	Starke	$46,600	2018
Steuben	$46,412	2014	Steuben	$54,100	2018
Sullivan	$41,223	2014	Sullivan	$46,700	2018
Switzerland	$42,497	2014	Switzerland	$45,300	2018
Tippecanoe	$43,529	2014	Tippecanoe	$51,400	2018
Tipton	$53,917	2014	Tipton	$60,800	2018
Union	$44,796	2014	Union	$46,900	2018
Vanderburgh	$41,784	2014	Vanderburgh	$46,800	2018
Vermillion	$42,709	2014	Vermillion	$51,400	2018
Vigo	$40,091	2014	Vigo	$43,600	2018
Wabash	$45,849	2014	Wabash	$51,600	2018
Warren	$53,781	2014	Warren	$55,500	2018
Warrick	$60,551	2014	Warrick	$65,800	2018
Washington	$41,598	2014	Washington	$48,900	2018
Wayne	$35,220	2014	Wayne	$43,000	2018
Wells	$49,264	2014	Wells	$56,100	2018
White	$48,274	2014	White	$47,400	2018
Whitley	$52,081	2014	Whitley	$54,900	2018

Expert Solution

Trending now

This is a popular solution!

Step by step

Solved in 3 steps with 1 images

SEE SOLUTION Check out a sample Q&A here

Knowledge Booster

$Point Estimation, Limit Theorems, Approximations, and Bounds$

Learn more about

Need a deep-dive on the concept behind this application? Look no further. Learn more about this topic, advanced-math and related others by exploring similar questions and additional content below.