Question: can I just have the process for how to do those questions? because the data is too big, i can not post all Refer to

 can I just have the process for how to do those
questions? because the data is too big, i can not post all
can I just have the process for how to do those questions? because the data is too big, i can not post all

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. D E F G Lines of Number of Number of Year Lines of Code Code Procedures Users Developed Per Procedure 731 5 15 1999 380 9 4 1998 718 27 2 2001 662 9 9 1998 313 10 3 1999 691 29 7 1997 849 24 18 1997 957 10 5 1997 922 29 17 1999 288 22 7 1997 B ID Program Number Language 2 1 Html 3 2 Pascal 4. 3 Html 5 4 Html 6 5 Cobol 7 Cobol 1998 1997 Fortran 1999 1998 Pascal 2000 1999 C++ 2001 2000 C++ 2002 2003 2004 2005 2006 2007 2008 2009 2010 2011 2012 2013 2014 2015 2016 2017

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related Accounting Questions!