ScholarMatic | 24/7 Homework Help

ScholarMatic Will Help You Write Your Essays and Term Papers

Answered » You can buy a ready-made answer or pick a professional tutor to order an original one.

Stat using excel

by | Nov 30, 2023 | questions

5) Using the data from the hospital charges worksheet in chpt 4-1, and do the following.a) Generate an xy chart for age and LOS and show this chart on the excel spreadsheet.1) a) Use the data from hosp charges on worksheet 4-1, create a frequency distribution using a pivot table using count of age in the data field.2) Using the variable LOS on the hospital charges sheet in chpt 4-1 and do:a) Using nested =if() function create a new variable, LOS -1, which will take on the value “short” when LOS is less than four days, “medium” when LOS is four days to nine days, and “long” when LOS is 10 days and more.B) Create a frequency distribution of LOS-1 using the pivot table.3) Use data SWC worksheet in chpt 4-1, create variable IMR-1, where IMR-1 is 0 if IMR is less than 25, 1 if IMR is 25-74, and 2 if IMR is greater than 74.a) Create a new variable LEB-1, where LEB1 is 0 if LEB is less than 50, 1 if LEB 50 to 69, and 2 if LEB is greater than 69.b)Use the pivot table capability to produce a cross-tabulation for IMR-1 and LEb-1, with IMR-1 as the column variable and LEB1 as the row variable.( be sure to count the data field rather than sum it.)

Document Preview:

US IMR
SWC
Hospital charges
F
M
ID
Sex
DRG
Charges
Medicare
ICD-9
Diag
LOS
Age
Sex1
U5MR
IMR
LEB
Afghanistan
Albania
Algeria
Angola
Argentina
Armenia
Australia
Austria
Azerbaijan
Bangladesh
Belarus
Belgium
Benin
Bhutan
Bolivia
Bosnia and Herzegovina
Botswana
Brazil
Bulgaria
Burkina Faso
Burundi
Cambodia
Cameroon
Canada
Central African Rep.
Chad
Chile
China
Colombia
Congo
Congo, Dem. Rep.
Costa Rica
C么te d’Ivoire
Croatia
Cuba
Czech Rep.
Denmark
Dominican Rep.
Ecuador
Egypt
El Salvador
Eritrea
Estonia
Ethiopia
Finland
France
Gabon
Gambia
Georgia
Germany
Ghana
Greece
Guatemala
Guinea
Guinea-Bissau
Haiti
Honduras
Hungary
India
Indonesia
Iran
Iraq
Ireland
Israel
Italy
Jamaica
Japan
Jordan
Kazakhstan
Kenya
Korea, Dem. People’s Rep.
Korea, Rep. of
Kuwait
Kyrgyzstan
Lao People’s Dem. Rep.
Latvia
Lebanon
Lesotho
Liberia
Libya
Lithuania
Madagascar
Malawi
Malaysia
Mali
Mauritania
Mauritius
Mexico
Moldova, Rep. of
Mongolia
Morocco
Mozambique
Myanmar
Namibia
Nepal
Netherlands
New Zealand
Nicaragua
Niger
Nigeria
Norway
Oman
Pakistan
Panama
Papua New Guinea
Paraguay
Peru
Philippines
Poland
Portugal
Romania
Russian Federation
Rwanda
Saudi Arabia
Senegal
Sierra Leone
Singapore
Slovakia
Slovenia
Somalia
South Africa
Spain
Sri Lanka
Sudan
Sweden
Switzerland
Syria
Tajikistan
Tanzania
TFYR Macedonia
Thailand
Togo
Trinidad and Tobago
Tunisia
Turkey
Turkmenistan
Uganda
Ukraine
United Arab Emirates
United Kingdom
United States
Uruguay
Uzbekistan
Venezuela
Viet Nam
Yemen
Yugoslavia
Zambia
Zimbabwe
Alabama
Alaska
Arizona
Arkansas
California
Colorado
Connecticut
Delaware
Florida
Hawaii
Idaho
Illinois
Indiana
Iowa
Kansas
Kentucky
Louisiana
Maine
Maryland
Massachusetts
Michigan
Minnesota
Mississippi
Missouri
Montana
Nebraska
Nevada
New Hampshire
New Jersey
New Mexico
New York
North Carolina
North…

Attachments:


ScholarMatic: Explanation & Answer

Your ready answer from a verified tutor is just a click away for as little as $14.99


  

Click Order Now to get 100% Original Answer Customized to your instructions!

HOME TO CERTIFIED WRITERS

Why Place An Order With Us?

  • Certified Editors
  • 24/7 Customer Support
  • Profesional Research
  • Easy to Use System Interface
  • Student Friendly Pricing

Have a similar question?

PLAGIRAISM FREE PAPERS

All papers we provide are well-researched, properly formatted and cited.

TOP QUALITY

All papers we provide are well-researched, properly formatted and cited.

HIGHLY SECURED

All papers we provide are well-researched, properly formatted and cited.

ScholarMatic: Get Started

Assignment Writing Service

Feel safe and secure when placing an order on our portal!
Fruitful cooperation begins with solid guarantees, and we are professional enough to promise perfect results. Let’s get it started!