Question

Refer to the worksheet named SOFTWARE. This worksheet provides information about 2000 software programs (rows 2-2001, each row is a different software program). Some rows are hidden to enable you to see the first and last rows easily. Column A contains an ID number for each software program. The remaining columns describe each program in terms of lines of code (total, not per procedure), number of users, and so on.

9. Considering all 2000 software programs in the data set (this refers to all 2000 rows, each row is a separate software program), what is the total number of lines of code? _______________________________________ 10. How many of the programs (each row is a separate program) were developed during the year 2001? _______________________________________

11. What is the average number of users of programs written in Pascal? _______________________________________

12. Calculate and consider the lines-of-code-per-procedure (Lines-of-Code / Procedure). Across all programs in the data set, what is the range (difference between highest and lowest) of the calculated values for the lines-of-code-per-procedure? _______________________________________

13. Do any programs appear in the worksheet that were written in HTML during 1999, have 15 or more users, and have less than 10 procedures and at least 300 lines of code? If so, provide the ID numbers of programs that have these characteristics.

ID
Number
Program
Language
Lines of
Code
Number of
Procedures
Number of
Users
Year
Developed
Lines of Code Per Procedure

1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 Html Pascal Html Html Cobol Cobol Html Fortr

0 0
Add a comment Improve this question Transcribed image text
Request Professional Answer

Request Answer!

We need at least 10 more requests to produce the answer.

0 / 10 have requested this problem solution

The more requests, the faster the answer.

Request! (Login Required)


All students who have requested the answer will be notified once they are available.
Know the answer?
Add Answer to:
Refer to the worksheet named SOFTWARE. This worksheet provides information about 2000 software programs (rows 2-2001,...
Your Answer:

Post as a guest

Your Name:

What's your source?

Earn Coins

Coins can be redeemed for fabulous gifts.

Similar Homework Help Questions
  • 0 5 10 15 30 - Country B ---Country A 1997 1998 1999 2000 2001 2002...

    0 5 10 15 30 - Country B ---Country A 1997 1998 1999 2000 2001 2002 2003 2004 2005 2006 2007 2008 2009 2010 2011 2012 2013 2014 2015 2016 2017 2018 2019 Unemployment Rate 14) (5 pts) Country A experienced higher cyclical unemployment than country B in the period 2005-07 15) (5 pts) Increasing international trade and financial globalization help explain why the two countries business cycles tend to move together 16) (5 pts) Country B experienced an increase...

  • Write a program that will accept from the user a text file containing hurricane data along...

    Write a program that will accept from the user a text file containing hurricane data along with an output filename. The data consists of the year, the number of storms, the number of hurricanes, and the damage in millions of US Dollars. The first line contains the word “Years” followed by the first year listed and the last year listed separated by tabs. The following lines contain the data separated by tabs. A sample text file is available in this...

  • Answer using SQL statements 1)All information about rental with longest rental period. Rental period in days...

    Answer using SQL statements 1)All information about rental with longest rental period. Rental period in days must appear. 2)How much money earned from rental by car manufacturer’s country every year. 3)Show 20% of our best customers by total income. 4)Show customers who used our rental 2 or more times and customer’s average money spending less than average rental price; 5)Show customer count by each state (for state show 2 letters abbreviation). Results sort by customer count descending order then by...

  • Area Act Date Description Telecommunications Telecommunications Deregulation and Competition Act of 1996—an update to Communications Act...

    Area Act Date Description Telecommunications Telecommunications Deregulation and Competition Act of 1996—an update to Communications Act of 1934 (47 USC 151 et seq.) 1934 Regulates interstate and foreign telecommunications (amended in 1996 and 2001) Civil legal evidence Federal Rules for Civil Procedure (FRCP) 1938 As updated in 2006, specifies requirements for the storage, protection, and surrender of discoverable electronic data as used in federal civil proceedings Freedom of information Freedom of Information Act (FOIA) 1966 Allows for disclosure of previously...

  • Read this article. Then write a 250 word response on two of the programs you like...

    Read this article. Then write a 250 word response on two of the programs you like the most. Open source business intelligence software 1. BIRT BIRT is an open source BI program that CloudTweaks says is often viewed as the industry standard. BIRT boasts “over 12 million downloads and over 2.5 million developers across 157 countries.” Its users include heavyweights such as Cisco, S1, and IBM (which is also a BIRT sponsor). They also have maturity going for them, as...

  • 1.b) Create a Java application Lab3Part1b. Make sure you create a NEW project with the specific...

    1.b) Create a Java application Lab3Part1b. Make sure you create a NEW project with the specific name just given. You need to make sure the projects you create and submit have the correct names and the name of the file and name of the class are the same. The names are case sensitive. In this new project, set up your program to read in the data from the file SciFiDataBMTClean.txt using a Scanner. {file/Scanner setup 2 points}   Declare the variables...

  • Program Description: A bus has 28 seats, arranged in 7 rows and 4 columns: This seating...

    Program Description: A bus has 28 seats, arranged in 7 rows and 4 columns: This seating arrangement is mapped, row-wise, to a 1D-array of size 28: 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 0 1 2 3 21 22 23 24 25 Implement a well-structured Java program to enable a user to make and cancel seat reservations for the bus. The program uses Array to store the reservation information: 0...

  • You need not run Python programs on a computer in solving the following problems. Place your...

    You need not run Python programs on a computer in solving the following problems. Place your answers into separate "text" files using the names indicated on each problem. Please create your text files using the same text editor that you use for your .py files. Answer submitted in another file format such as .doc, .pages, .rtf, or.pdf will lose least one point per problem! [1] 3 points Use file math.txt What is the precise output from the following code? bar...

  • This course is actually Quantitative Methods and Analysis In Unit 2, you have learned about three...

    This course is actually Quantitative Methods and Analysis In Unit 2, you have learned about three different types of distributions: Normal, binomial, and Poisson. You can take data that you collect and plot it out onto graphs to see a visual representation of the data. By simply looking at data on a graph, you can tell a lot about how related your observed data are and if they fit into a normal distribution. For this submission, you will be given...

  • Need help starting from question 9. I have tried multiple codes but the program says it is incorrect. Case Problem 1 Da...

    Need help starting from question 9. I have tried multiple codes but the program says it is incorrect. Case Problem 1 Data Files needed for this Case Problem: mi pricing_txt.html, mi_tables_txt.css, 2 CSS files, 3 PNG files, 1 TXT file, 1 TTF file, 1 WOFF file 0 Marlin Internet Luis Amador manages the website for Marlin Internet, an Internet service provider located in Crystal River, Florida. You have recently been hired to assist in the redesign of the company's website....

ADVERTISEMENT
Free Homework Help App
Download From Google Play
Scan Your Homework
to Get Instant Free Answers
Need Online Homework Help?
Ask a Question
Get Answers For Free
Most questions answered within 3 hours.
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT