HMGT 400 Research and Data Analysis in Health Care-Exercise

Dataset: HMGTHOSP.csv (Please download dataset from the class).

Required program: RStudio or R Programming.

Author, Hossein Zare, PhD

Citation: Zare, H. (2017). HMGT 400 7980 Research and Data Analysis in Health Care-Exercise. UMGC.EDU

For each week exercise, For the RStudio codes and a video, please follow the class announcement page.

If you have chosen to work with Excel, please run the three linear regression models and complete the following tables.

Medicare and Medicaid Discharge Ratios:Medicare Discharges Total Hospital Discharges;Medicaid Discharges Total Hospital Discharges

Model 2:

Run a linear model to predict the impact of number of hospital beds (use bed-tot) on hospital net-benefit in non-teaching hospitals.

Hospital Characteristics	Coef.	ST. ERR	T Stat	P-values	Lower 95%	Upper 95%
Hospital beds
R Square

(Limit all results to 2 decimal places max)

Use the results from model 1 and model 2 and compare the results between teaching and non-teaching hospitals.

Model 4:

Now, include the Medicare and Medicaid discharge ratios in first model. How do you evaluate the impact of having higher Medicare and Medicaid patients on hospital net-benefit in non-teaching hospitals?

Hospital Characteristics	Coef.	ST. ERR	T Stat	P-values	Lower 95%	Upper 95%
Hospital beds
Medicare-discharge-ratio
Medicaid-discharge-ratio
R Square

(Limit all results to 2 decimal places max)

Based on your findings, please recommend 3 policies to improve hospital performance. Please make sure to use the final model for your recommendations.

There are 3 Steps involved in it

Step: 1

Get Instant Access with AI-Powered Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

Step: 3

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Entrepreneurship

Authors: Andrew Zacharakis, William D Bygrave

5th Edition

1119563097, 9781119563099

Students also viewed these Mathematics questions

Question

★★★★★

Watson Inc., a multinational company, has operating divisions in France, Mexico, and Japan as well as in the United States. The company reported the following information on its consolidated...

Answered: 1 week ago

Question

★★★★★

54. Independent trials, each resulting in a success with probability p, are performed until k consecutive successful trials have occurred. Let X be the total number of successes in these trial, and...

Answered: 1 week ago

Question

★★★★★

The following circuit operates if and only if there is a path of functional devices from left to right. The probability that each device functions is as shown. Assume that the probability that a...

Answered: 1 week ago

Question

★★★★★

Daryl Kearns saved $240,000 during the 30 years that he worked for a major corporation. Now he has retired at the age of 60 and has begun to draw a comfortable pension check every month. He wants to...

Answered: 1 week ago

Question

★★★★★

Due to significant changes to the financial environment in one of the main Omega's markets it is expected that the average collection period will increase to 50 days. Omega is in the process of...

Answered: 1 week ago

Question

★★★★★

According to Joint Publication 3-24, Counterinsurgency, why should precision engagement by airpower "be designed to employ [host nation] airpower resources to the greatest extent possible

Answered: 1 week ago

Question

★★★★★

The tension between my mother and me rapidly increased once I moved home from college as she gave me little to no privacy. I was mature, had a full-time job, and wasn't the same as before I left four...

Answered: 1 week ago

Question

★★★★★

The table below presents the tax revenue and spending for the government over five years. a. Under the "Budget Amount" column calculate the annual budget outcome. Instructions: Enter your answer as a...

Answered: 1 week ago

Question

★★★★★

According to valor how can the framework of virtue ethics the ride inside in the hell robot human interactions condition the social and emotional character of humans especially patients And caregivers

Answered: 1 week ago

Question

★★★★★

Extract B (lines 20-21) states that 'all vehicle owners should be forced to pay the full costs of their driving. This would incentivise people to consider using public transport, cycling or walking....

Answered: 1 week ago

---

Previous Question Next Question

Study smarter with the SolutionInn App

Services

• Sitemap
• Fun
• Definitions
• Become Tutor
• Study Help Categories
• Recent Questions
• Expert Questions

Company Info

• Security
• Copyrights
• Privacy Policy
• Terms & Conditions
• SolutionInn Fee
• Scholarship

Get In Touch

• About Us
• Contact Us
• Career
• Jobs
• FAQ
• Campus Ambassador

Secure Payment

Download Our App

© 2024 SolutionInn. All Rights Reserved

Hospial net benefits	total_hospital_beds	Medicare discarge ratio	Medicaid discarge raito	Non-_teaching_hospital
-1600000	168.92	0.303580133	0.322896723	0
-700000	138.02	0.588416119	0.099599886	0
-14000000	74.16	0.302196296	0.290046296	0
10700000	25.75	0.289898833	0.256809339	0
-12000000	19.57	0.60395338	0.041958042	0
1000000	20.6	0.437508197	0.210382514	0
53000000	493.37	0.19803318	0.346949622	0
2200000	237.93	0.174868344	0.216647162	0
5000000	14.42	0.424808989	0.275280899	0
-2600000	61.8	0.423599708	0.11395179	0
24000000	37.08	0.178763397	0.272052762	0
18000000	101.97	0.472831025	0.215604801	0
18000000	360.5	0.288865538	0.193043478	0
-14500000	210.12	0.22040049	0.221904373	0
17000000	354.32	0.39303188	0.138977896	0
64000000	252.35	0.307772625	0.270414889	0
17000000	273.98	0.259680452	0.211498343	0
47000000	273.98	0.259680452	0.211498343	0
41000000	273.98	0.259680452	0.211498343	0
1900000	0	0	0	0
-130379	111.24	0.487129909	0.17328442	0
3400000	120.51	0.561757563	0.113908629	0
5900000	13.39	0	1	0
800000	25.75	0.786374502	0.051792829	0
-200000	25.75	0.776992405	0.055696203	0
2600000	25.75	0.625835749	0.149758454	0
-1292057	25.75	0.611913113	0.345132743	0
1400000	25.75	0.602985915	0.126760563	0
500000	25.75	0.6672	0.123684211	0
-1155671	25.75	0.436366035	0.352019786	0
-201954	25.75	0.436366035	0.352019786	0
0	226.6	0.467867878	0.091139462	0
3000000	284.28	0.501005267	0.170080768	0
-200000	117.42	0.461452922	0.175121753	0
0	172.01	0.61789282	0.097144631	0
18000000	172.01	0.61789282	0.097144631	0
600000	59.74	0.312221884	0.208966565	0
10000000	30.9	0.740878528	0.089570552	0
400000	25.75	0.748746667	0.058333333	0
600000	0	0	0	0
-1500000	25.75	0.462666667	0.272182254	0
-1304811	220.42	0.572814413	0.117565953	0
-3000000	164.8	0.369642018	0.105160101	0
20000000	25.75	0.731674267	0.058631922	0
-2625058	24.72	0.702005305	0.045092838	0
5000000	442.9	0.468985445	0.105242662	0
-34000000	142.14	0.549189	0.14775	0
-1000000	691.13	0.404141953	0.093554066	0
-23000000	302.82	0.425044538	0.124969128	0
1100000	25.75	0.665868263	0.073353293	0
3600000	25.75	0.529232462	0.085281981	0
-763300	16.48	0.805241379	0.040229885	0
2700000	215.27	0.361794816	0.197934254	0
-2900000	354.32	0.550838819	0.029367089	0
-17000000	161.71	0.369785115	0.065193061	0
14400000	342.99	0.209010682	0.541401667	0
36000000	109.18	0.286194755	0.64037406	0
40000000	55.62	0.438535211	0.090766823	0
81000000	249.26	0.280541764	0.13055943	0
35000000	321.36	0.254144314	0.088841476	0
-26000000	287.37	0.254100701	0.056570418	0
11000000	322.39	0.324401171	0.313616398	0
29000000	309	0.473309751	0.28683482	0
12000000	185.4	0.382512808	0.067211515	0
1000000	25.75	0.467372804	0.249837345	0
8800000	250.29	0.317671412	0.196343027	0
13900000	107.12	0.53117661	0.135519557	0
17000000	71.07	0.502975477	0.11766163	0
-35000000	60.77	0.295028936	0.026681699	0
20000000	54.59	0.581078108	0.005867253	0
6000000	269.86	0.364648439	0.029696307	0
24000000	105.06	0.296636563	0.058882037	0
7600000	58.71	0.505925466	0.010093168	0
13000000	449.08	0.382512255	0.084986309	0
3000000	318.27	0.26298119	0.139873141	0
28000000	30.9	0.100284663	0.06196319	0
-700000	141.11	0.390190331	0.131552163	0
-8000000	287.37	0.416418745	0.03446287	0
19000000	84.46	0.382136352	0.148930818	0
17000000	11.33	0.654763158	0	0
17800000	196.73	0.267700498	0.249844334	0
25000000	115.36	0.498551216	0.024324927	0
1300000	25.75	0.542271605	0.083333333	0
43000000	329.6	0.552626371	0.109451575	0
4000000	86.52	0.518520581	0.156691191	0
4700000	266.77	0.221342135	0.092753483	0
-6000000	266.77	0.221342135	0.092753483	0
3500000	25.75	0.643442136	0.12388724	0
4300000	43.26	0.5135	0.178057554	0
59000000	806.49	0.192730514	0.124690502	0
62000000	314.15	0.327966858	0.059742714	0
25000000	269.86	0.482341259	0.064628517	0
98000000	379.04	0.391959844	0.024286366	0
68000000	478.95	0.325719685	0.052070104	0
10000000	458.35	0.308918994	0.167934925	0
21000000	58.71	0.417348022	0.167501252	0
5000000	25.75	0.536515998	0.216861351	0
-2800000	50.47	0.460086918	0.219512195	0
8000000	376.98	0.610907999	0.029145037	0
1568941	49.44	0.456	0.22610483	0
-231264	15.45	0.683949791	0.083682008	0
0	25.75	0.693231552	0.03562341	0
-116000000	529.42	0.407910082	0.104661347	0
9000000	817.82	0.283779083	0.152115018	0
12000000	150.38	0.412306399	0.147549599	0
7000000	56.65	0.560797699	0.07957814	0
8000000	226.6	0.52478149	0.048868056	0
-2500000	525.3	0.439464714	0.058191628	0
7000000	66.95	0.346080529	0.148220191	0
-900000	321.36	0.515212692	0.04594722	0
11000000	239.99	0.330526242	0.068579426	0
17000000	104.03	0.450265652	0.073922372	0
27000000	660.23	0.165445465	0.285399654	0
51000000	75.19	0.434444066	0.066439523	0
-3500000	568.56	0.355364448	0.081254455	0
5000000	140.08	0.398712897	0.087653921	0
40700000	43.26	0.474629897	0.055468505	0
-35000000	35.02	0.446374115	0.06875632	0
84000000	123.6	0.424942857	0.116326531	0
3100000	244.11	0.39176257	0.082681564	0
-2000000	41.2	0.324401371	0.291727851	0
11000000	71.07	0.472718617	0.099034359	0
7000000	12.36	0.498176	0.024	0
300000	25.75	0.554660241	0.05060241	0
1177092	84.46	0.607421965	0.069364162	0
54000000	530.45	0.379954338	0.079620853	0
34000000	174.07	0.215498184	0.061406405	0
-2300000	232.78	0.486572792	0.115093681	0
-11100000	121.54	0.296278373	0.05017196	0
-1500000	25.75	0.387774359	0.128205128	0
-1700000	25.75	0.770569014	0.102816901	0
4100000	16.48	0.719529412	0.053475936	0
20000000	25.75	0.540411215	0.023364486	0
1400000	49.44	0.785	0.118705036	0
300000	146.26	0.530943207	0.086279109	0
10700000	32.96	0.460871413	0.290116897	0
10600000	349.17	0.641327618	0.03654485	0
3200000	112.27	0.150455105	0.509896008	0
1600000	22.66	0.848351816	0.070745698	0
3000000	138.02	0.381389708	0.149513213	0
-2100000	50.47	0.495700159	0.187799043	0
2000000	95.79	0.618789936	0.123171445	0
5900000	120.51	0.225183569	0.537869063	0
-3000000	25.75	0.783423687	0.056166056	0
9000000	25.75	0.662036484	0.102819237	0
1800000	25.75	0.862175676	0.081081081	0
-413579	48.41	0.560281039	0.22425409	0
2000000	25.75	0.944811189	0.062937063	0
1500000	25.75	0.606710098	0.087947883	0
1200000	25.75	0.733993399	0.179867987	0
63000000	299.73	0.44631661	0.389673648	0
22000000	103	0.494078386	0.168412883	0
22000000	67.98	0.54511425	0.173977695	0
-7000000	262.65	0.412189715	0.19385082	0
5000000	290.46	0.515068213	0.102496621	0
8000000	413.03	0.532373525	0.082276821	0
74000000	310.03	0.350445502	0.319630408	0
-23000000	306.94	0.399876812	0.0576373	0
2600000	77.25	0.713887714	0.129373474	0
56000000	43.26	0.484699482	0.20984456	0
1200000	22.66	0.683117296	0.077534791	0
3000000	13.39	0.539930636	0.094412331	0
2100000	179.22	0.486862132	0.282917899	0
6000000	88.58	0.674854	0.206138017	0
8500000	25.75	0.895638009	0.054298643	0
-10000000	136.99	0.591148961	0.143583781	0
-100000	99.91	0.667724528	0.201415094	0
-1600000	100.94	0.52626823	0.182442093	0
5600000	221.45	0.42505522	0.125560976	0
13000000	23.69	0.691609756	0.107317073	0
200000	25.75	0.717843179	0.146079484	0
300000	25.75	0.705325714	0.158857143	0
-1000000	193.64	0.369952866	0.249335167	0
-3000000	172.01	0.413104353	0.17745975	0
-500000	169.95	0.606041459	0.088165836	0
700000	25.75	0.844451128	0.060150376	0
2200000	25.75	0.672467802	0.199111769	0
5100000	25.75	0.769289987	0.105331599	0
28000000	297.67	0.448559015	0.075492031	0
-1200000	101.97	0.60900243	0.089116932	0
-9000000	427.45	0.473046001	0.174937916	0
45000000	163.77	0.480228741	0.065478401	0
9000000	222.48	0.391984898	0.225018877	0
5000000	349.17	0.390791038	0.204913487	0
17000000	174.07	0.475660904	0.05435888	0
49000000	345.05	0.525568577	0.125080489	0
11600000	124.63	0.381377441	0.253686728	0
-7200000	86.52	0.490372049	0.154863078	0
18000000	148.32	0.547862579	0.123863811	0
185000000	187.46	0.479182779	0.219960861	0
9000000	142.14	0.36845606	0.321873356	0
-2000000	153.47	0.504774714	0.256893073	0
32000000	146.26	0.457411843	0.099531616	0
11900000	96.82	0.516512182	0.137895283	0
25000000	51.5	0.461290581	0.164328657	0
41000000	268.83	0.459508893	0.245380763	0
3200000	84.46	0.612048387	0.073252688	0
400000	25.75	0.350285182	0.114631873	0
10000000	25.75	0.534011299	0.214689266	0
44000000	482.04	0.51754664	0.133522028	0
10100000	25.75	0.392661479	0.037451362	0
24000000	162.74	0.587374361	0.133970839	0
22000000	25.75	0.666347893	0.335632184	0
8600000	79.31	0.460076677	0.020766773	0
21600000	25.75	0.439912088	0.195604396	0
17000000	39.14	0.595017544	0.035818713	0
23000000	31.93	0.425654575	0.082295615	0
4400000	25.75	0.650092308	0.097435897	0
4900000	418.18	0.521285721	0.028067039	0
1300000	25.75	0.789945355	0.063752277	0
14600000	37.08	0.355509294	0.055762082	0
6600000	175.1	0.607927575	0.031963048	0
102000000	25.75	0.479746382	0.148173673	0
1600000	228.66	0.384584534	0.109600162	0
1600000	228.66	0.384584534	0.109600162	0
17500000	228.66	0.384584534	0.109600162	0
1500000	25.75	0.56951028	0.220560748	0
3100000	16.48	0.908585366	0.038109756	0
3100000	25.75	0.491714034	0.050308914	0
3800000	25.75	0.329759056	0.026958719	0
4100000	25.75	0.329759056	0.026958719	0
64000000	250.29	0.434278945	0.25848997	0
16000000	194.67	0.181794271	0.024860386	0
85000000	25.75	0.656227704	0.075901328	0
-1700000	500.58	0.321355506	0.063191011	0
2900000	25.75	0.628868941	0.095152603	0
1400000	25.75	0.720330781	0.168453292	0
9000000	142.14	0.536015068	0.191021818	0
20000000	25.75	0.684661157	0.066115702	0
2000000	101.97	0.488779421	0.249196141	0
5100000	25.75	0.506472502	0.110766847	0
60000000	216.3	0.527479514	0.089794602	0
800000	25.75	0.552804598	0.198275862	0
1300000	25.75	0.555404073	0.112540193	0
-600000	60.77	0.512659243	0.194320713	0
300000	25.75	0.513373333	0.165	0
1200000	17.51	0.613025641	0.14957265	0
-200000	50.47	0.525262421	0.100769769	0
5500000	25.75	0.702315789	0.078947368	0
1500000	25.75	0.551965167	0.150943396	0
10000000	25.75	0.810833333	0.03125	0
8400000	170.98	0.321175707	0.186022253	0
1223051	135.96	0.60531956	0.196272176	0
1900000	14.42	0.7645	0.015625	0
0	22.66	0.72172134	0.086419753	0
4500000	25.75	0.630621053	0.172368421	0
100000	25.75	0.564755906	0.031496063	0
45000000	269.86	0.458436909	0.189471609	0
22000000	207.03	0.55027336	0.219170456	0
23000000	100.94	0.578313503	0.159348442	0
4700000	36.05	0.523230918	0.038647343	0
7300000	49.44	0.476571429	0.293542074	0
10900000	295.61	0.327461787	0.17389448	0
1300000	25.75	0.736167247	0.020905923	0
900000	22.66	0.783234783	0.034782609	0
1700000	21.63	0.319492537	0.059701493	0
600000	25.75	0.794285714	0.067099567	0
79466	16.48	0.782748603	0.039106145	0
400000	18.54	0.657841584	0.024752475	0
-16918	23.69	0.807902041	0.016326531	0
781083	18.54	0.569842324	0.085062241	0
5600000	182.31	0.472970879	0.071438818	0
600000	54.59	0.470518717	0.044117647	0
-100000	25.75	0.411687898	0.186305732	0
62000000	25.75	1.112	0	0
800000	81.37	0.495752322	0.102167183	0
14000000	12.36	0.576763485	0.058091286	0
47000000	234.84	0.435976066	0.050170303	0
6600000	153.47	0.601342835	0.087727633	0
700000	21.63	0.588569038	0.108786611	0
100000	23.69	0.744556522	0.04057971	0
1300000	25.75	0.540293785	0.028248588	0
200000	48.41	0.616851574	0.037481259	0
-600000	20.6	0.9366639	0.024896266	0
-200000	25.75	0.58247619	0.067363531	0
42000000	389.34	0.421796689	0.126858693	0
-200000	25.75	0.600870175	0.043859649	0
11000000	118.45	0.559308927	0.036609558	0
2900000	162.74	0.447563479	0.139113992	0
-6800000	98.88	0.507044789	0.083679266	0
2900000	57.68	0.504722003	0.102108037	0
31000000	54.59	0.393131313	0.214141414	0
-300000	18.54	0.7784	0.013043478	0
352825	25.75	0.84512	0.026666667	0
-71876	17.51	0.697564576	0.040590406	0
0	50.47	0.538156611	0.265725289	0
200000	25.75	0.842097087	0.063106796	0
-937959	16.48	0.728551724	0.051724138	0
-922765	16.48	0.758919708	0.065693431	0
-3800000	70.04	0.4557814	0.134707574	0
-5000000	94.76	0.438360802	0.04413849	0
-4000000	439.81	0.521084681	0.204210276	0
27000000	43.26	0.613431138	0.161676647	0
300000	25.75	0.553346062	0.180190931	0
300000	93.73	0.480047915	0.215157798	0
-764428	16.48	0.632111369	0.16937355	0
-1500000	16.48	0.632111369	0.16937355	0
-1700000	25.75	0.602917556	0.103782735	0
16300000	41.2	0.529196539	0.018541409	0
-21000000	92.7	0.544826794	0.187559809	0
3000000	67.98	0.473757613	0.243940336	0
-500000	255.44	0.458457299	0.28340658	0
-5100000	482.04	0.507012826	0.053294033	0
4400000	75.19	0.549253792	0.226744186	0
200000	23.69	0.682591775	0.151454363	0
-700000	25.75	0.7365888	0.064	0
6600000	25.75	0.591446266	0.100182149	0
-300000	77.25	0.425014827	0.047446458	0
3200000	50.47	0.648666667	0.224358974	0
0	25.75	0.683	0.079136691	0
300000	25.75	0.683	0.079136691	0
210000000	1289.56	0.319082172	0.03641135	0
1500000	92.7	0.409121264	0.168327035	0
-400000	25.75	0.531644556	0.254067584	0
1000000	25.75	0.725308271	0.122180451	0
-700000	25.75	0.634140541	0.17027027	0
45000000	54.59	0.736599869	0.033398821	0
3000000	97.85	0.434016814	0.162271104	0
25000000	318.27	0.489556007	0.127581042	0
2000000	225.57	0.466006484	0.075983041	0
2000000	346.08	0.442553123	0.02755327	0
3100000	207.03	0.528816167	0.209012386	0
15000000	373.89	0.536843576	0.02840761	0
-14000000	127.72	0.480907429	0.040427449	0
10000000	109.18	0.412388018	0.175921659	0
12000000	162.74	0.520580239	0.116656523	0
37000000	291.49	0.47640678	0.020241434	0
-10000000	130.81	0.282909309	0.396737504	0
8000000	468.65	0.232957467	0.214817675	0
1100000	47.38	0.650646724	0.041666667	0
0	317.24	0.489799266	0.032594659	0
18000000	256.47	0.315925053	0.130631579	0
19000000	985.71	0.258256448	0.281828883	0
70000000	193.64	0.560720493	0.055518562	0
39000000	132.87	0.32307759	0.345051882	0
-2000000	239.99	0.536833004	0.018790619	0
-2000000	444.96	0.37704602	0.315871369	0
0	25.75	0.338983359	0.044629349	0
4000000	179.22	0.484131112	0.047587934	0
21000000	375.95	0.485713692	0.042599861	0
8200000	35.02	0.858609836	0	0
4000000	126.69	0.343881265	0.079562044	0
4000000	91.67	0.480077815	0.042648709	0
-1000000	26.78	0.723512821	0.032051282	0
600000	20.6	0.592054608	0.013651877	0
900000	25.75	0.820022346	0.027932961	0
3100000	15.45	0.814422535	0	0
-392811	25.75	0.689321492	0.007104796	0
-600000	11.33	0.804158192	0.039548023	0
200000	25.75	0.689749503	0.035785288	0
1800000	25.75	0.591706422	0.051987768	0
-400000	49.44	0.376793388	0.036363636	0
400765	15.45	0.627282051	0	0
-200000	67.98	0.563900049	0.03233709	0
-1400000	15.45	0.681548387	0.017921147	0
-1100000	84.46	0.50495089	0.049822064	0
7100000	25.75	0.754002205	0.024255788	0
-700000	47.38	0.51757007	0.03868104	0
5600000	25.75	0.606829817	0.009845288	0
11700000	25.75	0.644938175	0.05986261	0
4600000	8.24	0.741333333	0	0
1300000	25.75	0.655214371	0.046706587	0
1300000	90.64	0.411230189	0.135429769	0
900000	25.75	0.545849899	0.030425963	0
300000	80.34	0.43482875	0.039981511	0
800000	45.32	0.545975035	0.013869626	0
7000000	25.75	0.626906883	0.175101215	0
3100000	25.75	0.65442236	0.029503106	0
2300000	25.75	0.683445844	0.035264484	0
1400000	50.47	0.659751196	0.050239234	0
1200000	50.47	0.568412135	0.045792788	0
3600000	59.74	0.559232558	0.039405685	0
4200000	24.72	0.604280112	0.056022409	0
3400000	25.75	0.788990476	0.026984127	0
-500000	194.67	0.348718053	0.026033691	0
170000000	1023.82	0.288741549	0.086736962	0
8000000	417.15	0.312304683	0.078845463	0
40000000	294.58	0.438013716	0.044578074	0
52000000	25.75	0.55881519	0.017721519	0
500000	242.05	0.311357595	0.076623587	0
8000000	101.97	0.024534963	0	0
-14000000	158.62	0.637338677	0.029308617	0
59000000	70.04	0.507802833	0.078753541	0
800000	210.12	0.464284303	0.042569365	0
-4500000	210.12	0.464284303	0.042569365	0
4200000	41.2	0.330358744	0.270553064	0
5900000	32.96	0.418458206	0.049746193	0
-100000	25.75	0.561295238	0.104761905	0
161293	12.36	0.605466192	0.010676157	0
-952557	25.75	0.821009346	0.018691589	0
600000	15.45	0.763969466	0.022900763	0
1600000	25.75	0.515800939	0.054460094	0
1500000	20.6	0.652290503	0.05027933	0
4000000	80.34	0.159075653	0.028026135	0
14000000	245.14	0.432495207	0.161325664	0
-6200000	108.15	0.387344274	0.031716762	0
2000000	82.4	0.486579611	0.09316533	0
300000	20.6	0.692116183	0.024896266	0
-600000	25.75	0.271400593	0.18694362	0
3400000	17.51	0.732713178	0.062015504	0
1200000	16.48	0.354324649	0.06012024	0
-400000	25.75	0.71880663	0.060773481	0
7300000	25.75	0.458304138	0.265448684	0
11500000	38.11	0.311620022	0.192911947	0
6200000	32.96	0.32778939	0.247706422	0
11100000	16.48	0.4726	0.033333333	0
200000	25.75	0.50028145	0.025586354	0
-1000000	25.75	0.50028145	0.025586354	0
7300000	15.45	0.767955801	0.049723757	0
1400000	25.75	0.4951875	0.115234375	0
0	55.62	0.303690243	0.050593702	0
3700000	25.75	0.566973684	0.092105263	0
-2000000	144.2	0.496371014	0.160326087	0
80000000	622.12	0.243375807	0.089538312	0
3000000	117.42	0.315475671	0.312948684	0
13000000	88.58	0.342059762	0.209165903	0
7000000	59.74	0.337837896	0.031132582	0
1100000	25.75	0.453182568	0.137809187	0
13400000	88.58	0.314655255	0.115538914	0
30000000	104.03	0.332752992	0.228781284	0
100000	184.37	0.413886693	0.089779785	0
200000	318.27	0.371694083	0.024493721	0
13700000	189.52	0.325333708	0.224277375	0
-2200000	74.16	0.35559454	0.202439733	0
40000000	46.35	0.462872305	0.142620232	0
25000000	224.54	0.383825567	0.17136335	0
-500000	20.6	0.654503937	0.045275591	0
3600000	49.44	0.354455152	0.243143069	0
43000000	172.01	0.283962927	0.038926648	0
1400000	17.51	0.443297297	0.078828829	0
34000000	203.94	0.292547368	0.067928815	0
17000000	203.94	0.292547368	0.067928815	0
3000000	25.75	0.294526192	0.050618011	0
900000	24.72	0.423376147	0.059633028	0
300000	25.75	0.600283186	0.048672566	0
2795092	25.75	0.46246404	0.078173859	0
1300000	25.75	0.475076032	0.037653874	0
3300000	14.42	0.657090909	0.063636364	0
0	21.63	0.562247191	0.06741573	0
104144	21.63	0.562247191	0.06741573	0
2300000	21.63	0.562247191	0.06741573	0
1100000	169.95	0.463029166	0.089468255	0
-1600000	144.2	0.479888631	0.154126616	0
7000000	93.73	0.595123442	0.158624849	0
2500000	43.26	0.496499744	0.077316948	0
5000000	163.77	0.500928787	0.397819531	0
800000	18.54	0.725770992	0.080152672	0
-800000	25.75	0.574345178	0.074873096	0
2900000	25.75	0.589765182	0.070175439	0
-200000	22.66	0.694561514	0.104100946	0
-300000	22.66	0.694561514	0.104100946	0
20000000	337.84	0.554932412	0.265552995	0
61000000	577.83	0.430442325	0.045958659	0
55000000	233.81	0.554271713	0.224995429	0
-4000000	103	0.562841674	0.086136177	0
20400000	63.86	0.404323377	0.064516129	0
3000000	22.66	0.651423341	0.105263158	0
25000000	185.4	0.39287948	0.058426404	0
3200000	196.73	0.495121692	0.12936547	0
4300000	21.63	0.626107366	0.210986267	0
-500000	25.75	0.275029008	0.398473282	0
3900000	22.66	0.284546311	0.635792779	0
2000000	737.48	0.36061435	0.205604108	0
88000000	206	0.1772211	0.359837693	0
189000000	362.56	0.347641904	0.139783257	0
3000000	129.78	0.509884194	0.189134809	0
3500000	125.66	0.420701794	0.067093382	0
11000000	25.75	0.660973439	0.095477387	0
4300000	50.47	0.326142962	0.299189388	0
1000000	25.75	0.492335878	0.251908397	0
4200000	20.6	0.571027027	0.162162162	0
243363	25.75	0.862015504	0.007751938	0
-600000	20.6	0.546468571	0.131428571	0
121949	25.75	0.42646595	0.086618877	0
322258	25.75	0.410004376	0.062363239	0
218425	25.75	0.779678161	0.091954023	0
800000	25.75	0.354871212	0.147727273	0
-1200000	25.75	0.769846154	0.012820513	0
347145	20.6	0.539485149	0.083451202	0
3042552	25.75	0.733446809	0.074468085	0
1200000	8.24	0.986113208	0	0
378285	25.75	0.881931034	0.068965517	0
26000000	263.68	0.377032464	0.187463768	0
25000000	104.03	0.397677624	0.12019802	0
19000000	127.72	0.25313497	0.127442194	0
5000000	154.5	0.418943011	0.089516129	0
-1400000	22.66	0.272191045	0.498507463	0
4200000	25.75	0.323606277	0	0
1200000	25.75	0.404897098	0.158311346	0
3200000	16.48	0.593066667	0.139393939	0
-717820	25.75	0.947259259	0.037037037	0
700000	25.75	0.415720074	0.218232044	0
20650006	15.45	0.252727273	0.290909091	0
0	25.75	0.746116129	0.019354839	0
-424181	25.75	0.715945205	0.059360731	0
635290	25.75	0.9035	0	0
2700000	25.75	0.340252991	0.143019943	0
17000000	287.37	0.439784438	0.112174168	0
15000000	287.37	0.439784438	0.112174168	0
388041	16.48	0.593066667	0.012121212	0
1900000	25.75	0.346433622	0.280186791	0
500000	25.75	0.598893741	0.07860262	0
100000	25.75	0.598893741	0.07860262	0
-157211	25.75	0.636970874	0.024271845	0
2300000	25.75	0.963733333	0.024242424	0
1900000	25.75	0.568128588	0.111366246	0
1300000	25.75	0.672297994	0.068767908	0
955597	23.69	0.687863081	0.10391198	0
1600000	20.6	0.757734513	0.053097345	0
1100000	25.75	0.611432024	0.081570997	0
100000	13.39	0.675142857	0.107142857	0
0	19.57	0.615822785	0.142405063	0
1500000	24.72	0.759751553	0.096273292	0
5500000	25.75	0.596406977	0.104651163	0
52000000	354.32	0.368605336	0.117434775	0
30000000	267.8	0.417999186	0.180930422	0
2100000	21.63	0.52952381	0.095238095	0
1000000	25.75	0.705742389	0.093676815	0
200000	16.48	0.826234637	0.027932961	0
300000	25.75	0.583389163	0.115763547	0
178579	18.54	0.485985185	0.071604938	0
84202	20.6	0.676869565	0	0
3100000	25.75	0.616289157	0.138554217	0
3400000	25.75	0.652277056	0.058441558	0
60000000	303.85	0.353196143	0.135054555	0
71000000	482.04	0.496118269	0.130522766	0
69000000	201.88	0.467440443	0.144621422	0
36000000	183.34	0.297750803	0.244793526	0
0	161.71	0.38040452	0.055508475	0
36000000	72.1	0.44933403	0.060115003	0
12800000	119.48	0.441990058	0.129246065	0
12000000	150.38	0.495474821	0.211068639	0
3300000	25.75	0.594189899	0.077777778	0
9000000	437.75	0.554410472	0.008200421	0
16000000	249.26	0.514224044	0.049570648	0
15000000	298.7	0.533458409	0.020411016	0
-3000000	208.06	0.443458998	0.093877551	0
10000000	304.88	0.492894419	0.026677979	0
10000000	252.35	0.417756806	0.040866137	0
9000000	90.64	0.517114823	0.018267223	0
41000000	299.73	0.380452394	0.08080754	0
8800000	145.23	0.652214955	0.017912901	0
19100000	113.3	0.488665541	0.052494244	0
41000000	311.06	0.378062082	0.028624236	0
3000000	347.11	0.392505766	0.050971019	0
-58000000	241.02	0.425138307	0.020934862	0
-3000000	132.87	0.54065482	0.009451796	0
-5000000	135.96	0.482761004	0.012389958	0
21000000	217.33	0.437088181	0.031383956	0
-58000000	0	0	0	0
89000000	217.33	0.25046335	0.129403109	0
-3000000	476.89	0.588495238	0.02408359	0
8000000	302.82	0.409541235	0.109089377	0
2000000	104.03	0.394986425	0.066257272	0
3000000	509.85	0.351839096	0.086295899	0
-7000000	176.13	0.400817732	0.047019583	0
-7400000	87.55	0.567737651	0.12502562	0
1200000	168.92	0.406888367	0.051793496	0
4300000	23.69	0.411954944	0.025031289	0
-2400000	198.79	0.48364992	0.062045091	0
-2500000	119.48	0.51627682	0.053975364	0
0	127.72	0.545645734	0.050382561	0
300000	66.95	0.293467669	0.030075188	0
3000000	76.22	0.418201729	0.051873199	0
14000000	135.96	0.457133363	0.233947014	0
-300000	93.73	0.455144186	0.034026928	0
5000000	289.43	0.412330236	0.028145104	0
12000000	145.23	0.478786879	0.045570615	0
5000000	107.12	0.517209302	0.184436494	0
-1000000	89.61	0.497200622	0.186236392	0
-2100000	69.01	0.426916831	0.143476547	0
12700000	209.09	0.545327168	0.007986549	0
18000000	209.09	0.545327168	0.007986549	0
1000000	209.09	0.545327168	0.007986549	0
-6900000	25.75	0.552742188	0.145507813	0
-1185914	114.33	0.433677711	0.066062976	0
-1200000	114.33	0.433677711	0.066062976	0
-86000000	78.28	0.401503537	0.24486359	0
9000000	329.6	0.184958581	0.168873524	0
-5000000	134.93	0.342809816	0.068141981	0
3600000	295.61	0.537980038	0.195805764	0
1700000	72.1	0.420771061	0.124226559	0
9000000	152.44	0.402573593	0.068679632	0
4100000	48.41	0.528397163	0.225177305	0
-2600000	48.41	0.528397163	0.225177305	0
-1000000	154.5	0.426007743	0.032486113	0
-2900000	59.74	0.437426841	0.021357985	0
6600000	103	0.551890847	0.088971006	0
7000000	273.98	0.503602979	0.019227846	0
15100000	84.46	0.694154422	0.14319139	0
8000000	17.51	0.704065217	0.014945652	0
-4000000	151.41	0.543255014	0.055259926	0
-6700000	180.25	0.346310977	0.235427706	0
18000000	103	0.612641686	0.202771272	0
2000000	164.8	0.42260589	0.037328831	0
800000	148.32	0.565200125	0.018576335	0
1100000	41.2	0.625638171	0.059642147	0
2800000	120.51	0.36611576	0.033324981	0
8000000	144.2	0.454499569	0.074297535	0
4000000	375.95	0.461817048	0.042906862	0
4000000	168.92	0.306672646	0.018637892	0
20000000	159.65	0.345926326	0.040385265	0
300000	25.75	0.537166421	0.169366716	0
600000	16.48	0.881134948	0.031141869	0
-300000	15.45	0.733186813	0.03021978	0
5000000	315.18	0.611169904	0.0119094	0
-2700000	98.88	0.496645559	0.220509947	0
2500000	264.71	0.388371504	0.04776485	0
-400000	87.55	0.483441578	0.141502276	0
6000000	107.12	0.398942357	0.078290794	0
12000000	25.75	0.455371115	0.126142596	0
-1000000	381.1	0.459747657	0.289916155	0
43000000	113.3	0.473947468	0.344164636	0
15000000	128.75	0.609894702	0.297687387	0
1700000	187.46	0.385177106	0.219582433	0
1100000	24.72	0.753290323	0.035842294	0
47000000	445.99	0.415190612	0.100532703	0
40000000	104.03	0.573740665	0.375763747	0
6600000	116.39	0.208324051	0.279631761	0
28000000	105.06	0.453352771	0.142767375	0
35000000	61.8	0.393510539	0.164165773	0
-5500000	189.52	0.517258864	0.226146475	0
107496	25.75	0.976756757	0	0
2000000	65.92	0.541534356	0.023015344	0
-624619	82.4	0.356874419	0.209011628	0
65000000	476.89	0.281138753	0.239979295	0
2100000	132.87	0.592791439	0.296571304	0
-700000	25.75	0.697965588	0.180316586	0
-1200000	25.75	0.73769578	0.049067713	0
80000000	787.95	0.275086065	0.216314501	0
15200000	43.26	0.266476684	0.034974093	0
-124159	25.75	0.533357466	0	0
157485	0	0.969174312	0.009174312	0
-1800000	23.69	0.951615385	0	0
110728	18.54	0.827328	0.024	0
130726	11.33	0.549752809	0.04494382	0
-200000	25.75	0.63765035	0	0
-7806	20.6	0.743488372	0.023255814	0
599945	25.75	0.835553073	0.06424581	0
685013	21.63	0.95611215	0.037383178	0
-152755	14.42	0.79505314	0.048309179	0
300000	14.42	0.876613139	0.04379562	0
-1577870	17.51	0.571505976	0.039840637	0
-827495	17.51	0.571505976	0.039840637	0
312761	17.51	0.571505976	0.039840637	0
-191527	17.51	0.571505976	0.039840637	0
-1000000	25.75	0.471650516	0.141382049	0
-700000	25.75	0.715770115	0.061302682	0
0	24.72	0.549956522	0.043478261	0
500000	25.75	0.788778667	0.029333333	0
447732	24.72	0.80487619	0.104761905	0
477440	22.66	0.735050847	0.06779661	0
-816092	20.6	0.795775	0.021875