the following excel sheet contains the data about number of hours of charging,temperature and discharging time
simple 3 variable regression gives a very unstable model as correlation coefficient between the two independent variables(charging time and temperature) has very high absolute value
If you use a model Y = B0 + B1X1 + B2X2, the VIF for your terms is small. So, you don't need to worry about the correlation.
Using the model:
Battery discharging = 11.90 + 0.3291 Battery charging - 0.3188 Out door temperature
From this model, I got:
Fit SE Fit 95% CI 95% PI
5.88291 0.360004 (5.16840, 6.59741) (3.73503, 8.03078)
So, I would expect a computer with 4hrs of charge and an external temp of 23 degrees is 5.88hrs.
Thank you for your answer
But consider the coefficient of determination ,it's value is 0.86 for your model for the entire dataset.
please look at the excel sheet attached
i have sorted the dataset on the values of outside temperature,the coefficient f determination comes out to be 0.434 for the first 47 records.
this indicates that the relationship between charging time and discharging time is not likely to be linear at low temperatures.
that implies that this model works poorly for low temperatures.
Hiiiii everyone! I have an enquiry on statistical analysis. I was looking for many forum and it's still cannot solve my problem. I want to compare means of two groups of data but only with two...
03 March 2021 8,796 3 View
I want to analyses the proportion of swimming sperm of three species of fish in two salinities. To analyse the proportion of swimming sperm in a Generalized Linear Model, I would use a Binary...
03 March 2021 2,297 3 View
What's the best way to measure growth rates in House sparrow chicks from day 2 to day 10? Since, the growth curve from day 2 to 10 won't be like the "Logistic curve" it might not follow logistic...
03 March 2021 1,401 3 View
I have an experiment with 28 participants The independent variable is the times 1, 2, 5, and 10 used as the cross hairs during a task These 4 times were tested using 4 different blocks, each...
03 March 2021 9,692 2 View
I just wanted to check if I need to run a linear regression separately if I am using PROCESS MACRO to run mediation analysis. Thank you.
02 March 2021 4,359 3 View
Hello, I have a mechanism where air rises due to convective flows. In this simulation, nothing is driving the air except this. I understand that the Boussinesq approximation only works for small...
02 March 2021 4,910 3 View
Hello! I have a dataset of n=3000 nested within 8 countries with approximately 200 or 400 responses in each country. I originally planned to perform multilevel modelling with 4 dependent variables...
02 March 2021 6,865 1 View
To dear Researchers, I was analyzing a series of concentration for estimation of Real-Time PCR efficiency. The concentration was 1:10. I used MS-excel to evaluate Slope. The result of slope was -8...
01 March 2021 8,683 4 View
Hello, Could you please share any interesting research explaining how to choose the number of hidden layers and nodes per layer in case of regression problems using ANN? Thank you, any help would...
01 March 2021 6,200 3 View
Hi everyone, I would like to ask how I can download BibExcel software for MacOs? There are some links which are supported by Windows but I could not find it for Mac. or is there any other software...
01 March 2021 652 1 View