Yоu wаnt tо creаte а functiоn in Excel to allow you to quickly calculate the speed of a sound wave. The formula used to calculate this is as follows: Speed = Distance / Time In the space provided below, type the lines of code that are needed to create a user-defined function called Speed to calculate this formula. Assume the distance and time will be entered as numerical values with or without decimals. (6 points)
(2) Dr. Red (а) Dr. Red оperаtes а medical clinic that serves a lоw incоme population, many of whom receive Medicaid. Dr. Red is a dedicated general practitioner, and often works long days. Dr. Red employs a billing specialist, Agatha, and a receptionist, Eugene. Agatha sees how hard Dr. Red works, and believes his medical care is essential to the neighborhood. When Agatha bills general patient appointments, she can bill 300A (an appointment for 20 minutes) or bill 600B (an appointment for 45 minutes). Agatha starts to bill all appointments for 600B and submits the bills without informing Dr. Red. Eugene hears Agatha talking on the phone, “Oh yes, Dr. Red is so busy. He sees so many patients per day. Just last week he worked a 65 hour week!” Eugene knows Dr. Red took a two hour lunch last week with his wife Bunny, and took last Friday off to sail on his yacht. Eugene thinks something fishy is going on, and he is certain someone is going to find out Agatha billed Medicaid for many more hours than when Dr. Red was actually with patients. (b) Eugene starts really digging into the billing records and patient files, and becomes convinced that Dr. Red is violating federal laws relating to his billing practices. Agatha sees Eugene digging around in the billing records patient and fires him. Agatha tells Eugene he had no right to access patient medical records and billing files. Eugene thinks he should not have been fired. Eugene thinks he was only fired because Agatha found him searching through files and knows that he was going to report Dr. Red for what he believes are legal violations. Eugene wonders if he has any recourse, because he thinks it was unfair that he was fired. (Note: for the sake of time, do not address the Qui Tam action in this question, but focus on the other main issue you identify.) (c) While Eugene was digging around in Agatha’s files, Eugene also found four letters from Rose Pharmaceuticals from the past six months. Each letter says, “Dear Dr. Red, We applaud you on your dedication to your patients. We would like to reward your commitment to providing your patients our very best Statin Drug by showing our appreciation. Please find enclosed a $250 gift card to Ulele Fancy Restaurant to enjoy dining at its finest.” Eugene suspects Dr. Red had an inappropriate business arrangement with Rose Pharmaceuticals, and is certain someone will find out.