Linear Regression #2

THE DATA ARE THE PERCENTAGE EXAMINATION MARKS (Y) AND TH
PERCENTAGE								
ATTENDANCE AT CLASSES (X) FOR A GROUP OF 40 STUDENTS,								
								
PERFORM A LINEAR REGRESSION OF Y ON X AND USE THIS TO DETERMINE TH
FOLLOWING								
AMOUNTS.								
								
INTERCEPT (a)				12.60463992				
GRADIENT (b)				0.699961906				
PREDICTED VALUE OF Y WHEN X = 60%								
PREDICTED VALUE OF Y WHEN X = 0%								
CORRELATION COEFFICIENT				0.81440364				
COEFFICIENT OF DETERMINATION								
ESTIMATED ATTENDANCE WHEN MARK =  50%								
								
MARK %	ATTENDANCE %	WORKING AREA IF NEEDED						
45	48							
55	40							
65	90							
89	90							
100	100							
20	5							
35	15							
25	10							
45	50							
55	45							
69	80							
75	70							
86	80							
79	85							
25	12							
10	89							
0	2							
56	70
68	80
78	80
50	60
45	55
90	85
100	95
95	80
75	90
40	85
20	10
25	15
30	20
0	10
50	60
40	67
57	89
68	78
58	60
30	20
21	12
25	25
78	9

--
stura
-----------------------------------------------------------------------
sturae's Profile: http://www.excelforum.com/member.php?action=getinfo&userid=2998
View this thread: http://www.excelforum.com/showthread.php?threadid=49979

0
1/10/2006 4:24:25 PM
excel 39879 articles. 2 followers. Follow

1 Replies
740 Views

Similar Articles

[PageSpeed] 32

Look in HELP for the following functions:

LINEST
TREND
FORECAST

and also look at some of the other statistical functions.

That should provide all the information you need for your assignment.





On Tue, 10 Jan 2006 10:24:25 -0600, sturae
<sturae.21ffzn_1136910301.2812@excelforum-nospam.com> wrote:

>
>THE DATA ARE THE PERCENTAGE EXAMINATION MARKS (Y) AND THE
>PERCENTAGE								
>ATTENDANCE AT CLASSES (X) FOR A GROUP OF 40 STUDENTS,								
>								
>PERFORM A LINEAR REGRESSION OF Y ON X AND USE THIS TO DETERMINE THE
>FOLLOWING								
>AMOUNTS.								
>								
>INTERCEPT (a)				12.60463992				
>GRADIENT (b)				0.699961906				
>PREDICTED VALUE OF Y WHEN X = 60%								
>PREDICTED VALUE OF Y WHEN X = 0%								
>CORRELATION COEFFICIENT				0.81440364				
>COEFFICIENT OF DETERMINATION								
>ESTIMATED ATTENDANCE WHEN MARK =  50%								
>								
>MARK %	ATTENDANCE %	WORKING AREA IF NEEDED						
>45	48							
>55	40							
>65	90							
>89	90							
>100	100							
>20	5							
>35	15							
>25	10							
>45	50							
>55	45							
>69	80							
>75	70							
>86	80							
>79	85							
>25	12							
>10	89							
>0	2							
>56	70
>68	80
>78	80
>50	60
>45	55
>90	85
>100	95
>95	80
>75	90
>40	85
>20	10
>25	15
>30	20
>0	10
>50	60
>40	67
>57	89
>68	78
>58	60
>30	20
>21	12
>25	25
>78	90

--ron
0
ronrosenfeld (3122)
1/10/2006 5:26:26 PM
Reply:

Similar Artilces:

Excel Macro #2
I need to create an Excel Macro tha will import a series of txt files, one below the other, automatically. The macro will be run every two weeks and each txt file will have additional rows. What I want to know is how to automatically position the curson to the next open cell in column A after the previous txt file was imported. Can anyone help? Range("A1").Offset(ActiveSheet.UsedRange.Rows.Count, 0).Select Dan E "Robert Blankenhorn" <Blankenhorn.B@cpcnet.co.richland.oh.us> wrote in message news:05ab01c35dc3$99bb7130$a001280a@phx.gbl... > I need to creat...

Recurring Appointments #2
Hi I am trying to set up recurring appointments in CRM 4.0. I have created two custom attributes and inserted them on the appointment form. The first attribute is a picklist with Yes/No for Recurring appointment (Default value is NO) and the second attribute is for the number of recurrences. I am aware that I can create a workflow which confirms that the Recurring appointment is Yes and creates a new appointment. I would like to ask if someone could please assist me with the number of recurrences. I need to fire the workflow for each number of recurrence. I am not quite sure how to d...

SMART Regression installation
Version: 2004 Operating System: Mac OS X 10.4 (Tiger) So I am taking a statistics class. Our textbook comes with a disk and instructions to install SMARTReg, which provides additional regression features for Excel. (Yes, I do have the analysis tool-pak installed.) However, the installation is for windows (it is an .exe file). I went to the website listed in the ReadMe file: www.gierus.ca/alex/smartreg but it is definitely not related to this program. <br><br>Is there a Macintosh version of this add-on available that anyone knows about? <br><br>Thanks. <br><...

1 account, 2 computers and 2 email addresses
Good evening, I've got one broadband email account on two networked computers, both using Outlook 2000. I want each computer to receive their own respective emails, however, both computers are receiving emails from both accounts. I just double checked Outlook on this computer and under Accounts, only the account I created for this computer is there. Why am I still getting the other emails? And how do I filter so that each computer gets it's own respective mail? Thanks. Frank Phrank <Phrank> wrote: > I've got one broadband email account on two networked computers, ...

Linear Programming
In Excel how do you set up a 3 variable linear programming problem on a spreadsheet with a a number of constaints using Solver? Franklin - See the tutorials and examples at www.solver.com. Or, search your drive for the file solvsamp.xls, which is installed when Solver is installed and which has a 3-variable nonlinear example that is easily converted to linear. - Mike www.mikemiddleton.com +++++++++++++++++++ "Franklin" <anonymous@discussions.microsoft.com> wrote in message news:0c5a01c500bf$8f5038c0$a501280a@phx.gbl... > In Excel how do you set up a 3 variable ...

Division 2 numbers
Hello I want generate at random numbers in 2 columns that results division was be only integer example: 6/2=3 or 4/2=2 or 9/3=3 i will be do that in visual basic thx for help gregor -- E-mail odczytasz po kliknieciu na: http://cerbermail.com/?Sa8ZdOqkxK Nr gadu-gadu: 36786 One way: Option Explicit Sub testme() Dim myRng As Range Dim wks As Worksheet Dim MaxNumber As Long Dim MinNumber As Long Dim maxResult As Long Dim minResult As Long MaxNumber = 25 MinNumber = 3 maxResult = 10 minResult = 2 Set wks = ActiveSheet With wks ...

linear and exponential graphs and x,y intercepts
I have two lines one linear (y=mx+c) and one exponential (y=c^bx) and they intercept each other. I believe it is possible to calculate where the lines intercept. Although I can do this by graphing the data, it takes time and allows for user error so a calculation would speed things along greatly. The problem: So for the first line using the equation y=mx+c the numbers for the 13kPa line are y=0.0021x+9e-16 And for the exponential line (y=c^bx) which we produce to using the myograph is y=0.0022^0.0046x (^=Exp) I know that the two lines intercept at 1613. But no matter what I try I can&...

Public folders in OWA #2
I had a problem earlier this week with getting OWA to work, finally got it working, when i added the defualt app under IIS. But when it comes up now if you go to public folders it shows it as a Directory rather than the normal outlook contacts look....you can browse it all the way to the contact, like this: Wednesday, October 05, 2005 8:51 AM 893 Bob Ponder.EML Any ideas? Sounds like you modified something in IIS Admin, then had those settings propagate down to the Public vdir. The only way I've ever been able to fix the view problem you are mentioning is to reinstall...

GWAT #2
Can anyone help me with this question please? What is the GWAT in 5.5 called in 2003 and why is it better? Thanks in advance GWART = Gateway Address Routing Table. Exchange 200x uses link state routing instead of a GWART. This article will help: http://support.microsoft.com/?id=263249 -- Neil Hobson Exchange MVP For Exchange news, links and tips, check: http://www.msexchangeblog.com "Slipper1" <cunn1l1ngus@hotmail.com> wrote in message news:Pjegd.84$T34.48@fe2.news.blueyonder.co.uk... > Can anyone help me with this question please? > > What is the GWAT in 5...

transfer data range from criteria in 2 combo boxes
i have 2 combo boxes "com1" and "com2" i want the value in "com1" to help me decide which columns to target and i would like "com2" to decide which rows to target from another worksheet "sheet2" example: if the value of "com1" was "red" and the value of "com2" was "5/1/10" then i can return C5-C35 from "sheet2" into "a1-a31" in the original sheet example: if the value of "com1" was "blue" and the value of "com2" was "5/2/10" then...

Money 2008 #2
Are they making a UK version as we have not had one for some time, I use 2006 version which was last they produced for us. I'm not aware of any new one at present. The last UK version was 2005. On the Money support page, it says: "Note: Money 2006, 2007, and Money Plus are only supported in the United States and Japan. Money 2005 is supported in countries outside the United State and Japan, including France and the United Kingdom. Money 2003 and 2004 are no longer supported. Please contact the appropriate support center for your product." Which implies to me, that Money ...

printing problems #2
When some of my coworkers print timelines, the arrows show up but notthe text of the milestones. We use different kinds of printers or print to Adobe. Has anybody else seen this? What's the fix. What version of Visio? Are all service packs installed? What operating system(s)? Which printers are successful and which ones are not? Are all printer drivers up to date? Randall Arnold "Sherrie" <sb6633@sbc.com> wrote in message news:%23PAQ07ioDHA.1708@TK2MSFTNGP12.phx.gbl... > When some of my coworkers print timelines, the arrows show up but notthe > text of the mi...

Outlook Favorites Won't Save, Messages wrong on Outlook Today #2
Re-posting a message from a couple of weeks ago, hoping for better luck this time. I have Outlook 2003 running on XP Pro. Original message, with some additional info in brackets: A few days ago, I lost all my favorites. Also, the Messages section on Outlook Today no longer shows the number of unread messages, and if I click on a folder under Messages, nothing happens. For the Favorites, once I add them back in, it works fine until I reboot, and then they are gone again. I do close and re-open Outlook after adding my folders, so it should be saved properly, and it appears to be working w...

PostMessage #2
I have a Dialog based application . I want to post message from this dialog to another class which is alos part of the same application. Say When I click a button,this dialog posts a message to another class. How should I achieve this? how should I know about the class recieve that particular message? Pls guide me with sample code. Regards YKUT First off, you're going to be posting to a window not a class even though it kind of looks that way since the class/object has the code that handles the message. You can do this by using the CWnd PostMessage() or SendMessage() funcitons. Yo...

Owa login problem #2
Initialy there was an error ASP 0115 Errors in IIS This what I 've done ; Click Start, point to Programs, click Windows NT 4.0 Option Pack, click Microsoft Internet Information Server, and then click Internet Service Manager. Expand Internet Information Server. Right-click the computer name, and then click Properties. In the Master Properties drop-down list box, click WWW Service, and then click Edit. Click the Home Directory tab, and then click Configuration. On the Process Options tab, click to clear the Enable Debug Exception Catching check box. Click OK to close the Application C...

Microsoft CRM 1.2 Unspecified Error
I have an installation of Microsoft CRM which was running fine until a problem with the domain controller running on an HP server, for some reasons the domain controller refused to boot properly until I found out that an HP service was causing the error, the HP service was disabled the the DC was fine, after that MSCrm refused to come up, the Security service refused to start and was coming up with an Unspecified Error. I checked the dependencies and nothing related to the HP service that was disabled. Any help would be appreciated ...

forwarding #2
When i forward an email to someone theres no problem, but when i close the original message, it is gone in the inbox folder meaning it is automatically deleted how can i stop that, i didn't change any of the defaul settings of the microsoft outlook, i hope you can help me with my problem as soon as possible. thank you. It might not be gone. Check your view. View, Currnet View. Make sure it's not set to Unread messages. -- Patricia Cardoza Outlook MVP www.cardozasolutions.com Author, Special Edition Using Microsoft Outlook 2003 ***Please post all replies to the newsgroups*** &...

outlook background #2
How do I limit users choice of using backgrounds? Mike Turn off HTML mail, please!!!! --� Milly Staples [MVP - Outlook] Post all replies to the group to keep the discussion intact. All unsolicited mail sent to my personal account will be deleted without reading. After furious head scratching, Mike asked: | How do I limit users choice of using backgrounds? | | Mike ...

problem launching excel #2
I am using MSOFFXP ... I cannot get excel to come up by double clicking on my file....I hav to launch the excel program, click on open find the file and the select it... even if excel is running minimized clicking on a file in the explore will not open that file...the only way for me to open my files is b going through the excel program... my word program works as advertised... any suggestions?? Thanks \\ G -- Message posted from http://www.ExcelForum.com Hi try the following: goto 'Tools-Options-General " and uncheck "Ignore other Applications" Exit Excel and try a...

TO: #2
This is a multi-part message in MIME format. ------=_NextPart_000_000A_01C4C235.C6CDD550 Content-Type: text/plain; charset="iso-8859-1" Content-Transfer-Encoding: quoted-printable When I hit the (to) button in order to add a e-mail address some of the = address are with last name first and some are with the first name first. = I have entered them all the same and would like for them to be arrange = by last name the same as they are in the contacts part of outlook. I = was under the impression that the address came from the contacts part of = outlook. --=20 Regards, Ron =...

cell reference #2
I have a list of numbers in column A. I wish at the bottom to return the maximum value in column A using =max(a1:a100) but i also want the cell reference of this value. how can i do this. thanks Use the MATCH function - it will give you the relative position of the maximum value in your range, and as this begins at A1 then this is the same as the row. If you have two maximum values, however, it will only report the first occurrence. Hope this helps. Pete lees news wrote: > I have a list of numbers in column A. I wish at the bottom to return the > maximum value in column A using =m...

copy range #2
hi is it possible to perform one after another: copy range then clear another range and finally paste copied range to its destination something like rng.copy rng1.clearcontents range("a1").PasteSpecial Paste:=xlPasteValues doesnt work it stops when paste as seems like clipboard is empty thx mcg Without knowing what you're really doing, sometimes you can just change the order and you'll be fine: rng1.clearcontents rng.copy range("a1").pastespecial paste:=xlpastevalues Macgru wrote: > > hi > is it possible to perform one after another: > copy r...

CRM Mobile 1.2 and territory codes
By default when choosing Terrirtory Code as a criteria in a CRM Mobile Accounts form the only choice is "default value". How can this list be populated with the correct value of Territories? ...

Sharing Folders #2
We have several csa's that need to answer email sent to our customer service email address. How can I allow them to all view the messages and respond using their own email address? I also want to know how many messages each of them responded to each day. Any suggestions? Thanks in advance. In news:1160056739.115655.121970@b28g2000cwb.googlegroups.com, CableGuy <cabletech1@gmail.com> typed: > We have several csa's that need to answer email sent to our customer > service email address. How can I allow them to all view the messages > and respond using their own email ...

Offline Public folders #2
Hello, Is there a way to get the Public folders offline so I can have access to the contacts,calendar and stuff from the office on my laptop even when I am not connected to the Exchange Server in my office? This way I can syncronize my public folders whenever I am in the office and have access to the info at home.Any help or pointers in the right direction would be greatly appreciated.The version ou Outlook is 2002 and Exchange Server is 2000. Lakshman. Drag the PFs in question to the public folder "favorites" in your folder view - then you can select them for offlie use in ...