• 100% Satisfaction Guarantee
SusanAthena, Master's Degree
Category: Calculus and Above
Satisfied Customers: 102
Experience:  Tutor for Algebra, Geometry, Statistics. Explaining math in plain English.
12809769
Type Your Calculus and Above Question Here...
SusanAthena is online now

### Customer Question

I would like access to the results of your answer on "The status of Counties is Important. There are more than 3,000 US counties...." Can you help me with this?
Submitted: 1 year ago.
Category: Calculus and Above
Expert:  Mr. Glenn replied 1 year ago.
Hi Thank you for using this site. Is this a math question? Kindly post your complete question. Thanks
Customer: replied 1 year ago.
I replied directly to the link with another customers' same question. You should have your IT and marketing departments look into that....bear with me for several minutes will I type it .... Thank you.
Expert:  Mr. Glenn replied 1 year ago.
ok
Customer: replied 1 year ago.
The gentleman I thought I was replying to already answered the following question and provided a link to another customer. Do you have access to that to send it immediately? Here is the problem for a Quantitative Business Analysis class:The status of counties is important. There are more than 3,000 US counties. The median household income (in dollars), average years of schooling, average lifespan (in years), and average number of people per household of 100 chosen counties are provided.Data collected for a sample of 100 counties in 20XX are contained in the file named Counties, linked at the bottom of the page. Use all 100 data points.Managerial Report
Prepare a report (see below) using the numerical methods of descriptive statistics presented in this module to learn how each of the variables contributes to the success of a county. Be sure to include the following three (3) items in your report.
1.Descriptive statistics (mean, median, range, and standard deviation) for each of the four variables along with an explanation of what the descriptive statistics tell us about the counties.
2.Use the z-score to determine which counties, if any, should be considered outliers in each of the four variables. If there are any outliers in any category, please list them and state for which category they are an outlier. Describe which method you used to make your determination.
3.Descriptive statistics (correlation coefficient) showing the relationship between median household income (in dollars), and each of the other three variables. Thus, that makes a total of three correlation coefficients. Evaluate the relationships between median household income (in dollars) and each of the other three variables. Use tables, charts, graphs, or visual dashboards to support your conclusions.Write a report that adheres to the Written Assignment Requirements under the heading “Expectations for CSU-Global Written Assignments” found in the CSU-Global Guide to Writing and APA Requirements. As with all written assignments at CSU-Global, you should have in-text citations and a reference page. An example paper is provided in the MTH410 Guide to Writing with Statistics, linked at the bottom of the page.Your report must contain the following:
•A title page in APA style.
•An introduction that summarizes the problem.
•The body of the paper should answer the questions posed in the problem by communicating the results of your analysis. Include results of calculations, as well as charts and graphs, where appropriate.
Customer: replied 1 year ago.
His ID was manas11 if that is helpful.
Expert:  Mr. Glenn replied 1 year ago.
I am not sure if he is available these days. If it is fine with you, I will try to answer this again?
Customer: replied 1 year ago.
Ok. Here is the data file. https://app.schoology.com/external_tool/205987757/launch
Expert:  Mr. Glenn replied 1 year ago.
it needs a user name and a password, do you have right now the excel file?
Customer: replied 1 year ago.
County Median household income in dollars Average years of schooling Average lifespan in years Average number of people per household
Alpine 42799 11.8 75.9 2.2
Andrews 56598 13.1 79.7 2.5
Angelina 41789 11.7 75.7 2.2
Appling 41593 11.7 75.5 2.6
Arapahoe 51925 12.5 78.1 3
Atlantic 35427 10.3 73 2.5
Austin 55470 13.1 79.5 2.2
Bailey 39152 11.4 74.6 2.4
Ballard 59512 14 80.1 2.8
Bastrop 39631 11.5 74.8 2.9
Baylor 43075 11.9 76.2 1.9
Bee 47985 12.2 77.5 2.7
Belmont 41175 11.7 75.2 2.7
Benewah 59839 13.9 78.9 3.2
Benton 41211 11.7 78.1 2.1
Borden 59620 14 80.9 2.5
Bosque 46873 12.1 77.2 2
Bowie 55241 12.9 78.9 2.7
Brazoria 43042 11.8 78.4 2.7
Brazos 42242 11.8 75.9 3.2
Brewster 55536 13.1 78.4 2.5
Briscoe 40064 11.6 75.2 2.9
Brooks 54202 12.6 78.5 2.2
Brown 50142 12.3 77.9 1.8
Burleson 58115 13.5 80.4 2.2
Butler 57472 13.5 80.3 2
Caldwell 39920 11.6 75 2.4
Calhoun 48539 12.2 77.7 2.6
Callahan 52155 12.5 78.1 2.3
Calumet 38453 11.1 73.9 1.9
Camp 56918 13.3 80.1 2.5
Carson 45745 12.1 76.8 2.4
Casey 35545 10.5 73.3 2.1
Castro 37647 10.8 73.5 2.6
Charles 51951 12.5 78.1 3.2
Cherry 54248 12.6 78.6 2.4
Chilton 56913 12.4 80.1 2.4
Clinton 42518 11.8 75.9 2.7
Cochise 39550 11.4 74.7 2.7
Coke 45753 12.1 76.9 3.2
Coleman 55344 13 79.2 2.9
Collin 57294 13.4 80.3 2.7
Collins 38916 11.2 74.2 2.7
Comal 47085 12.1 78.3 2.3
Concho 47703 12.2 77.4 2
Cone 39275 11.4 74.6 3
Cooke 53163 12.5 78.4 2.2
Cotton 35124 10.2 73 2
Coweta 40793 12 73.1 2.9
Craven 54863 12.7 78.8 2.2
Crockett 39582 11.4 74.8 2
Dakota 53529 12.6 78.5 2.3
Dale 38668 11.7 74.2 2.1
Dallam 39820 11.6 75 1.8
Dallas 56972 13.4 78.8 2.4
Daniels 48640 12.3 78 2.7
Dearborn 57777 13.5 80.4 2
Delaware 35831 10.7 73.3 2
Denton 51417 12.4 78.1 2.5
DeWitt 51311 12.4 78 2.9
Dickens 46677 12.1 77.1 2.7
Dimmit 36620 11.1 73.5 2.1
Durham 46660 12.1 77 1.8
Duval 54668 12.7 78.7 2.6
Eastland 55060 12.8 78.9 2.3
Ector 41648 11.7 75.7 2.8
Edward 45157 12 76.8 2.6
Erie 56785 13.3 79.7 2.8
Essex 43613 11.9 76.3 2.8
Gregg 54416 12.6 78.7 2.1
Grimes 53695 12.6 78.5 2.2
Guam 35968 10.8 73.3 2.8
Hale 38098 12.2 73.7 2.7
Hall 38375 11 73.8 2.7
Jones 55043 12.8 78.8 2.1
Kent 41928 11.8 75.8 3
Lincoln 57064 13.4 80.2 2.6
Marion 38444 11 73.8 2.5
Niagra 37975 11 73.6 2.5
Ontario 56027 13.1 79.7 2.6
Orange 35442 10.5 73 3.1
Oxford 55998 13.1 79.6 2.3
Putnam 41332 11.7 75.4 2.9
Queens 47582 12.2 77.4 2.1
Richmond 52193 12.5 78.1 1.8
Riverside 44685 12 76.7 2.4
Sullivan 37692 10.9 73.6 2.3
Sutter 47253 12.2 77.3 1.8
Tipton 53186 12.5 78.4 3.1
Trinity 50098 12.3 77.8 2
Union 58850 13.6 80.8 2.4
Wabash 58223 13.6 78.8 2
Washington 39193 12.2 74.6 3
Wells 51233 12.4 78 2.9
Wyoming 38956 11.3 74.4 2.9
Yates 41905 11.7 78.3 3
Yuba 39077 11.4 74.5 2.9
Ziebach 44500 12 76.4 2.4
Customer: replied 1 year ago.
County is the first column, then median household income in \$ (5 digits - i.e 38956), then average years in schooling (i.e 11.3), then average lifespan in years (i.e. 74.4), then average # ***** people in household (i.e. 2.9).
Customer: replied 1 year ago.
How do I paste the actual excel file? I was only able to transfer the data.....see above.
Customer: replied 1 year ago.
Expert:  Mr. Glenn replied 1 year ago.
When do you need the answer for this? (how many days from now?)
Customer: replied 1 year ago.
By the end of today, preferably. Deadline is tomorrow - midnight. That's why I was hoping I could just click on Manos11's link .. . .. . . but it was a dropbox file.
Expert:  Mr. Glenn replied 1 year ago.
Customer: replied 1 year ago.
CST - Louisiana
Expert:  Mr. Glenn replied 1 year ago.
Would you like to avail the private dialog box service so that out succeeding conversations including the answer, will not be anymore accessible to public? (and no one can access the answer except you, or using that service) I can now provide you my email. Do you want to avail that service?
Customer: replied 1 year ago.
No, that's not necessary. Just the answer.
Expert:  Mr. Glenn replied 1 year ago.
ah ok
Customer: replied 1 year ago.
: ))
Expert:  Mr. Glenn replied 1 year ago.
ok
Customer: replied 1 year ago.
My card was charged for the answer and I have not received an answer. Please reverse the payment and do not charge my card. I already finished the project since I did not hear whether you would be able to meet the deadline or not.
Customer: replied 1 year ago.
If you are unable to reverse the charge, please send me the answer by tonight, please. Thank you.
Expert:  Mr. Glenn replied 1 year ago.
ok